I know I can refresh the pivot table itself, and even all the pivot tables in a workbook.
But, what about the detail views generated from the pivot table? (when you double click on a value to see the underlying rows of data).
Now, I need to double click the appropriate cells again – and then get rid of the old detail views.
Is there a way to just get all of the detail views refreshed? Maybe with VBA?
1
Unfortunately, Excel does not natively offer a feature to automatically refresh all the detail views (drill-through sheets) generated from a PivotTable. However, you can automate this process using VBA. Below is an approach to refresh all detail views using VBA:
Steps to Refresh All Drill-Through Detail Views with VBA
-
Clear Old Detail Sheets: Write VBA code to identify and delete existing drill-through sheets.
-
Regenerate Detail Views: Automate double-clicking on the appropriate cells to regenerate the drill-through sheets.
Bhargav Gohel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1