ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My Excel 2007 filename is followed by [Group]. Why? (https://www.excelbanter.com/excel-discussion-misc-queries/248819-my-excel-2007-filename-followed-%5Bgroup%5D-why.html)

hkbarnett

My Excel 2007 filename is followed by [Group]. Why?
 
Many of the functions on the ribbon are inaccessible. I noticed that the file
name shown at the top of the spreadsheet is followed by "[Group]". I have
never seen that before on any spreadsheet, and have no idea how it got
labeled that way. I assume that has something to do with the inability to
access some functions, such as conditional formatting. How can I get rid of
[Group] so I can continue to work on the workbook?
Herb

Peo Sjoblom[_3_]

My Excel 2007 filename is followed by [Group]. Why?
 
You had at least 2 sheets selected (grouped) when you saved the workbook,
right click the sheet tab and select ungroup sheets and then save the
workbook


--


Regards,


Peo Sjoblom


"hkbarnett" wrote in message
...
Many of the functions on the ribbon are inaccessible. I noticed that the
file
name shown at the top of the spreadsheet is followed by "[Group]". I have
never seen that before on any spreadsheet, and have no idea how it got
labeled that way. I assume that has something to do with the inability to
access some functions, such as conditional formatting. How can I get rid
of
[Group] so I can continue to work on the workbook?
Herb





All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com