I'm having trouble with some Excel functionality. I have a spreadsheet that
is heavily dependent on the Outlining functions, and being able to 'roll up'
data. It has many rows that are merged, and contains many functions, and I
want to protect the sheet. Unfortunately, if you protect the sheet, the roll
up capabilities of the Outline function are no longer available. You're
essentially stuck with whatever view was visible when you protected the
sheet. Help!