Workbook saved as [Group]

[TheeConstress]

Hi all,
I'm working in a report for my work and I'm trying to change the filter on my data, though when I go to do this - I can't. I went to the Data tab on the Command Ribbon to clear the filter that way, but everything is greyed out. That's when I noticed that it is showing "[Group]" next to the file name at the top of the window.
I'm familiar with shared workbooks, but I've never seen it notated as [Group]. I checked Share Workbook under Review and it's not showing that it is shared... So I'm not sure how I enabled this or how to undo it. Can someone help me out?
I'm using Excel 2019.
Thank you!

 

[TheeConstress]

If anyone has an answer, I'm curious.
But I just clicked into a different sheet in the same workbook then back again and it no longer says [Group] and I'm able to change my filters.
So I solved my problem somehow.

 

[Peter_SSs]

Welcome to the MrExcel board!

The Group is referring to the fact that you have multiple worksheets selected at the same time - nothing to do with shared workbooks.

Say you are on 'Sheet1' of your workbook, if you hold the Ctrl key and click on the tab for, say 'Sheet3' (& possibly others) then you now have two (or possibly more) sheets selected and the 'Group' text will appear at the top. The reason that your filter options were greyed out is that your filter is only on one of the selected sheets so you cannot clear it on all of them. Excel greys out options that are not applicable to multi-sheet selections.

To clear the sheet grouping you can click on a sheet tab that is not one of the currently selected sheets (that is what you must have done) or else you can right-click on one of the currently selected sheet tabs and choose 'Ungroup Sheets'.

If you ever group sheets I would always try to remember to ungroup them as soon as possible. Otherwise you may end up adding/editing/deleting data on multiple sheets when you think you are only doing it on one.

Hope that clarifies a little for you.