If your pivot table is based on a large data source, it might respond very slowly when you add fields or move fields to a different area of the pivot table. To improve performance, try the following tips: Remove any pivot table styles and any other formatting, such as conditional formatting that you applied to [...]

If there are several pivot tables in your workbook, you might want to refresh all of them at the same time instead of refreshing each pivot table individually. To refresh all the pivot tables in the active workbook at the same time, display the External Data toolbar, and click the Refresh All button. Note: Using [...]

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, if your pivot table source data changes frequently, you might want to ensure that the pivot table is updated as soon as the file opens. You can set a pivot table option to refresh the pivot table automatically: Right-click a cell in the pivot table, and choose Table Options. Under Data options, [...]

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 [...]