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 file opens. If you can use macros in your Excel file, you can use an [...]

Pivot table macros can run painfully slowly, even if you have turned off screen updating and disabled events. To make the code run faster, you can try adding a line that turns off automatic updating in the pivot table. For example: Set pt = Worksheets("PivotSales").PivotTables(1) pt.ManualUpdate = True At the end of the code, you [...]

One of the benefits of using an Excel pivot table to analyze your data, is that you can use filters to focus on a specific part of the summarized results. Hiding some of the data with filters can be misleading though, if you can’t tell that filters have been applied. If you apply a filter [...]

If you have an Excel workbook that contains several pivot tables and multiple Excel Tables, you might want to identify which pivot cache each pivot table uses. To figure out which pivot cache a pivot table uses, you can use a macro to check the pivot table’s CacheIndex property and show the index number in [...]