workbook name suffixed by (Group) - why?

  • Thread starter Thread starter Truemouse2003
  • Start date Start date
T

Truemouse2003

A workbook has suddenly started to open with (Group) at the end of the name &
a lot of the functionality is not working. How do I prevent this and why has
it occured?
 
You have grouped two or more sheets together - right-click on a
worksheet tab and click on Ungroup sheets. Then save your file.

Hope this helps.

Pete
 
That means you have multiple sheets selected--look at the sheet tabs at the
bottom of the window.

You can rightclick on any of the selected sheets and choose "ungroup sheets".

This is a very nice way to change stuff on multiple worksheets at once. But if
you forget to ungroup the sheets, it's a way to screw up very quickly.

ps. You can click on the first sheet tab and ctrl-click on subsequent to group
sheets.
 
Sorry Gents, this was my first thought - the tabs were hidden & so I unhid
them & they weren't grouped! It is an option I commonly use but it's not
causing this problem.

Kevin
 
Maybe you're not looking at all the tabs.

Make sure you scroll the tab bar right or left.

Even better, if you select an ungrouped sheet tab, does the [group] go away?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Workbook Name Suffixed With Number 5
My Excel 2007 filename is followed by [Group]. Why? 1
formula between two workbooks 1
Can't update my workbook - Name bar shows as "[Group]" 2
Macro to push data to another workbook 0
personal.xls 3
Prevent multiple workbooks in same Excel instance 8

Back
Top