Grouped Workbooks

[Guest]

For some reason, when I open up 2 of my excel files, they show as [Group]
after the title of the workbook. It also prevents me from making changes to
the file unless I trick the system. Does anyone know how to remove this and
what may have cause this?

Thanks!

 

[Richard O. Neville]

The word [Group] is appearing because the individual sheets are, in fact,
grouped. Right-click on any sheet tab name and select Ungroup sheets. Look
at the title - [Group] will disappear. Sheets remain grouped or ungrouped
when documents are opened or closed.

 

[Dave Peterson]

Workbooks aren't grouped--but sheets within each workbook can be grouped.

Look at the sheet tabs at the bottom of the screen.
Rightclick on one of the grouped sheets and and select Ungroup Sheets.

Almost any changes you make to a sheet's that grouped with others is made to the
other sheets in that group. You may want to inspect your data looking for
problems.

Grouping sheets is a nice way to update common cells (headers???). But it can
be dangerous if you don't ungroup those sheets when you're done.

Remember to save the workbook the way you want (grouped or ungrouped sheets).

For some reason, when I open up 2 of my excel files, they show as [Group]
after the title of the workbook. It also prevents me from making changes to
the file unless I trick the system. Does anyone know how to remove this and
what may have cause this?

Thanks!

 

[Gord Dibben]

That means you have two or more worksheets selected(grouped)

Note which are grouped. They will be colored white.

Right-click on a sheet tab and "Ungroup"

NOTE: any changes made on one sheet while in group mode is replicated on any
other sheet in the group.

Carefully check the sheets that were grouped for changes.

How did it happen?

Maybe you CTRL + clicked on a sheet tab while another sheet was active.

See help on "group" for more info.


Gord Dibben MS Excel MVP