Prevent Collapsing of Pivot Table Rows

[CarolinaKB]

I have a pivot table with several text fields included in the Row Labels
area. These text fields are 1:1 with the key field of the row so the
expanding and collapsing behavior is superfluous. In fact, I do not want
the fields to be "collapseable" because if saved in a collapsed stated other
users may not realize why other data is not being displayed.

Is there a way to control this? I realize that I can use Expand All each
time but I would prefer that they not even be given the option of collapsing
the field.

 

[CarolinaKB]

Answered my own question; didn't look hard enough the first time.

Using Excel 2007, goto PivotTable Tools / Options and click the "+/-
Buttons" to remove the buttons, then protect the sheet.

 

[Shane Devenshire]

Hi,

I know you think you answered your own question, but...

1. If you are protecting the sheet then there is no need to turn off the
display of the +/- buttons. They don't work when the sheet is protected.

2. Let's suppose that when you turn on sheet protection you are checking the
User Pivot Table reports option. Turning the +/- buttons off does not stop
the pivot table from being expanded and collapsed. All one needs to do is
double-click a grouped row or column label item, or right click and choose
the Expand/Collapse options, or on the Data tab or the Pivot Table Tools,
Options....