Microft Excel {Group}

[tentnc]

On a spread sheet I have and update regularly has added the word "Group" to
the end of the name now and is now changing cells within the spread sheet.
How do I correct this?

Please help

 

[jsteensen]

I have been having the same problem - [Group] is added after the spreadsheet
name and the outline buttons (collapse/expand) don't function.

After copying and saving it outside of Excel it started working again - but
I don't know why.

 

[jsteensen]

This happens when multiple worksheets have been selected. Just right-click on
a tab and select Ungroup Sheets. Then [Group] will disappear and editting
will be limited to the current sheet.

 

[Jan Karel Pieterse]

Hi Tentnc,

On a spread sheet I have and update regularly has added the word "Group" to
the end of the name now and is now changing cells within the spread sheet.
How do I correct this?

You have control- or shift-clicked two or more tabs and now changes made to
one of them are done to all of them. Rightclick a tab and select ungroup or
select one of the grey tabs (if any).

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com