Is there a way a worksheet containing a pivot table can be protected, but still allow the user to sort within the pivot table?
Hi Brian,
Welcome to our forum!
In Worksheet Protection (Review tab > Protect Sheet) you can check the box to allow users to 'Use PivotTable & PivotChart'. This will allow sorting via the filter buttons on the PivotTable, but not via the Data tab.
Mynda
Hi Mynda - thanks I had not thought of doing it that way - this seems to get me partially to where I'd like to be. Using this approach allows me to sort by the labels in the row or columns, respectively. What I am hoping to do is sort by the values within a given column (think of how an Excel Table would work for example). I had attempted this using a simple right click inside a cell, then sort by values hi/low. This is what prompts the message about not being able to sort in a protected sheet. Do you know any way around this?
Hi Brian,
If you select a value cell, then click on the filter drop down in the row labels cell > More Sort Options... this opens a dialog box where you can sort by the value field.
Mynda
