I have a workbook that is shared (more than one person can access at a time).
All the pages have groups on them, ie. rows grouped together that you can collapse and expand.
When I try to save the workbook I get a warning pop-up that says "Selection is too large" It pops up one of these warnings for every sheet that I have the groupings on. Then the file saves.
The problem is that when I close the file and reopen it, all the sheets are in expanded form even though when I saved they were in collapsed form.
I tried expanding all and then save, it saves fine. So, it is just when saving have some or all of the groups collapsed.
Anyone know a way to stop this??
Bookmarks