Is there any workaround to the problem I'm facing when creating models for others in that they can group and ungroup unless I release the workbook before I send it to them for testing or is this part of the Excel 'protected workbook' setup?
Is there any workaround to the problem I'm facing when creating models for others in that they can group and ungroup unless I release the workbook before I send it to them for testing or is this part of the Excel 'protected workbook' setup?
Stay up-to-date with Modano developments including new example models, content and learning exercises.
This is a painful nuance with Microsoft Excel - i.e. that sheets can be protected while allowing users to continue collapsing and expanding grouped rows and columns, but once the workbook is saved, closed and re-opened, grouped rows and columns cannot be collapsed or expanded.
This issue means that when you provide modular workbooks created using Modano (which protects the sheets to ensure that the modules remain in intact) to Excel users without Modano installed, they will be unable to expand or collapse grouped rows or columns.
We have contacted Microsoft about this before over the years, as we can't see how it's not a bug, but they've never done anything to change this behaviour.
The workaround is to ask 3rd parties to create a Modano account and install the free Community Edition of Modano, as this will allow them to collapse and expand grouped rows within modular workbooks of any size.
Thanks Michael!