Name[Group]

[Ro]

I have a spreadsheet named XYZ [Group] and find that I cannot sort, filter, etc. in the spreadsheet. Is the reason why I can't use any of the functions because of the type of spreadsheet indicated by [Group]? How can I change this spreadsheet to allow normal functions to be used? I have already tried to copy and paste to new spreadsheet without any luck.

 

[Peo Sjoblom]

Right click a sheet tab, select ungroup and save the wb

--

Regards,

Peo Sjoblom

I have a spreadsheet named XYZ [Group] and find that I cannot sort,

filter, etc. in the spreadsheet. Is the reason why I can't use any of the
functions because of the type of spreadsheet indicated by [Group]? How can
I change this spreadsheet to allow normal functions to be used? I have
already tried to copy and paste to new spreadsheet without any luck.

 

[Ken Wright]

The sheets are simply grouped. If all sheets are groupoed then just click on
any tab to ungroup, or if not all sheets are grouped then click on any ungrouped
tab to ungroup the others, or just right click on any tab that is grouped and
select ungroup. You will now be able to do all those things. If you don't save
it then it will open up grouped again.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I have a spreadsheet named XYZ [Group] and find that I cannot sort, filter,

etc. in the spreadsheet. Is the reason why I can't use any of the functions
because of the type of spreadsheet indicated by [Group]? How can I change this
spreadsheet to allow normal functions to be used? I have already tried to copy
and paste to new spreadsheet without any luck.