I'd like to protect a spreadsheet that we are using so that other users can
view only.
There is some grouping of rows in the sheet which I'd like other users to be
able to switch between for different levels of detail.
However, when I protect the sheet excel will not allow the grouping to
change. (I have tried to protect only the relevant cells but still the same.)

Thanks for you help!

apr