Category Archives: Refresh

Refresh an Excel Pivot Table on a Protected Sheet

When you protect a worksheet, you can add a check mark in the options list, to allow the use of pivot tables and pivot charts. However, even with that option turned on, you can’t refresh an Excel pivot table on … Continue reading

Posted in Refresh | Leave a comment

Saving Source Data with Pivot Table File

When you create a pivot table in your workbook, the source data records are saved in a special memory area – a pivot cache.  Then, when you close the file, Excel can save the source data in this pivot cache, … Continue reading

Posted in Refresh | 8 Comments

Automatically Refresh a Pivot Table

It would be nice if a pivot table automatically updated, whenever its source data changes, but unfortunately, that doesn’t happen. If you add new records, or delete records, or edit the existing data, the pivot table doesn’t show the revised … Continue reading

Posted in Refresh | 4 Comments

Stop a Pivot Table Refresh

After you add new records to a pivot table’s source data, you have to Refresh the pivot table, to see the new data. If you have several pivot tables based on the same data source, all of them will be … Continue reading

Posted in Refresh | Leave a comment

Manually Clear Old Items in Pivot Drop Down

If you remove an item from your pivot table’s source data, it might still show up in the drop downs, even after you refresh the pivot table. In this example, a product name was originally “Whole Wheat”. In the source … Continue reading

Posted in Refresh | 2 Comments

Refresh Pivot Table on Protected Sheet

When you protect a worksheet in Excel, you’ll see a list of items that you can allow people to use, while the sheet is protected. One of those options is ‘Use PivotTable reports’, and if you add a check mark … Continue reading

Posted in Refresh | 2 Comments

Update Pivot Table From Text File

In addition to creating pivot tables from Excel data, you can also use external data sources, such as a text file, like the billing data shown below. Import the Data In this example, the billing data was imported to Excel … Continue reading

Posted in Refresh | Leave a comment

Remove Old Items from Excel 2010 Pivot Table Drop Downs

After you create an Excel 2010 pivot table, the source data may change.  New items might be added, and old items are sometimes removed from the data.  In this example, the East and Central regions are merged, and the Central … Continue reading

Posted in Refresh | Leave a comment

Refresh Excel Pivot Table Automatically

When you update a pivot table’s source data in Excel, the pivot table does not update automatically. You can set the pivot table to update when the Excel file opens, but that doesn’t help if you’re making changes after the … Continue reading

Posted in Refresh | 10 Comments

Improve Performance When Changing Pivot Table Layout

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 … Continue reading

Posted in Refresh | 3 Comments