[MJW]

All of a sudden an important file I use regularly has started opening with
[Group] at the end of the file name. As a result certain features such as
Goal Seek can not be used on any cells in the spreadsheet. How did this
happen and how do I "un-do" it ?

[Dave F]

Groups means your tabs are grouped together. Right click on one of the tabs
and select "ungroup."

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"MJW" wrote:

All of a sudden an important file I use regularly has started opening with
[Group] at the end of the file name. As a result certain features such as
Goal Seek can not be used on any cells in the spreadsheet. How did this
happen and how do I "un-do" it ?

[Gord Dibben]

This means you more than one worksheet selected.

On the sheet tab bar you will see that two or more sheet tabs are white in
color.

Those sheets are grouped.

Quite a handy feature if you want to do the same thing to several sheets at
once, like insert rows or format some cells etc.

Right-click and "ungroup" or select a sheet that is not in the group.

NOTE: have a good look at the sheets that were grouped.

What you have done to one will be done to all.

Can lead to some interesting but unwanted changes if you did not know the sheets
were grouped.


Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 16:44:13 -0800, MJW <MJW @discussions.microsoft.com wrote:

All of a sudden an important file I use regularly has started opening with
[Group] at the end of the file name. As a result certain features such as
Goal Seek can not be used on any cells in the spreadsheet. How did this
happen and how do I "un-do" it ?