Grouping

I have shared my model with a bank not using Modano and they are unable to expand and collapse grouped rows and columns within worksheets.

Is there some way around this with the bank needing to install the Modano Excel add-in or me having to unmanage the workbook? I'd rather leave it managed if possible.

Thanks, J.

Hi everyone,

I have a question with regard to the expanding of grouped rows and columns after sending a modular workbook top a client who does not have the Modano software. It seems that the client does not have the possibility to to expand or collapse the rows and columns as needed.

Is it possible to send the client the model without releasing it but with the worksheet protection options set so that the rows can be expanded and collapsed but all other protections remain in force?

Thanks!

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?