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??