You might have to make changes to a workbook that contains a pivot table. If someone else created that workbook, you may not be sure where to find the Excel table that was used as the pivot table’s source data. In some workbooks there can be several Excel tables, and it’s not immediately obvious which [...]

In Excel 2003, you protected a worksheet, and in the list of options, added a checkmark to allow all users of the worksheet to use PivotTable reports. However, you can’t create a new pivot table, or refresh a pivot table on the worksheet because some buttons on the PivotTable toolbar are disabled. When you protect [...]