Expand/Contract grouped columns in protected sheet

D

d333d

I´m trying to protect a sheet that has a pivottable with grouped
columns.
The problem is , after protecting the sheet , I can´t expand/contract
the table.
I get an error saying that I can´t use that command because it´s a
protected sheet.

Is there anyway around this? I.E. How can I protect a sheet, and still
expand/contract a pivottable?
 
Top