Hi,
For a long time I have used VBA code to refresh PivotTables on a protect sheet. The other day while manually protecting a worksheet, I noticed in the Allow users of the worksheet to list that there was an option to Use PivotTable reports. I was curious as this could save some coding time, so I tested it out. I protected a sheet with this option enabled and went to adjust a filter on my PivotTable. Excel gave me a message saying that I had to remove protection before I could make such a change. In fact I couldn't do anything with the PivotTable without a similar message being displayed.
So curious as to what this option is supposed to do, I opened up Excel's help window.
In the help article: Password protect worksheet or workbook elements I found an entry for Use PivotTable reports, it says: the clearing the check box from this option will prevent users from "Formatting, changing the layout, refreshing, or otherwise modifying PivotTable reports, or creating new reports". This suggests that putting a tick next to Use PivotTable reports will enable all of these abilities, yet placing a tick doesn't seem to make any change to my ability to interact with the PivotTable.
So long story short, does any know what actually is enabled when you put a tick next to the Use PivotTable reports option, or does my version of Excel have a bug? By the way, I am using Excel 2010 on Windows 7.
Regards,
John
For a long time I have used VBA code to refresh PivotTables on a protect sheet. The other day while manually protecting a worksheet, I noticed in the Allow users of the worksheet to list that there was an option to Use PivotTable reports. I was curious as this could save some coding time, so I tested it out. I protected a sheet with this option enabled and went to adjust a filter on my PivotTable. Excel gave me a message saying that I had to remove protection before I could make such a change. In fact I couldn't do anything with the PivotTable without a similar message being displayed.
So curious as to what this option is supposed to do, I opened up Excel's help window.
In the help article: Password protect worksheet or workbook elements I found an entry for Use PivotTable reports, it says: the clearing the check box from this option will prevent users from "Formatting, changing the layout, refreshing, or otherwise modifying PivotTable reports, or creating new reports". This suggests that putting a tick next to Use PivotTable reports will enable all of these abilities, yet placing a tick doesn't seem to make any change to my ability to interact with the PivotTable.
So long story short, does any know what actually is enabled when you put a tick next to the Use PivotTable reports option, or does my version of Excel have a bug? By the way, I am using Excel 2010 on Windows 7.
Regards,
John
