What does the [Group] in a file name mean?

E

EES

I have worked with 2 to 3 Excel files that have the
designation of "[Group]" in them. Does anybody know what
the relevance of this and if it is known to cause any
problems.

Thanks for your feedback.

EES
 
F

Frank Kabel

Hi
this indicated that you have 'grouped' several sheets (selected them
together). Simply select on single tab name to remove this.

Note: In group modus a change done on the active sheet will also be
done in all grouped sheets
 
G

Gord Dibben

EES

The [Group] means two or more worksheets are grouped together.

If you look at your sheet tabs, two or more will be white in color.

You can ungroup by clicking on one of the ungrouped sheets or by
right-clicking on a tab and selecting "ungroup sheets".

Potential problems.........whatever you have have done to one sheet while in
group mode will have been done to all sheets in the group.

i.e. entering data or formatting of one sheet will be replicated on the
others.

Gord Dibben Excel MVP
 
J

JE McGimpsey

It means you've selected more than one worksheet in the workbook.

You can ungroup them by right-clicking a grouped sheet's tab and
choosing UnGroup.

It can cause all kinds of problems, since any change to one grouped
worksheet is also made in all grouped sheets.
 
Top