ExcelBanter - How can I refresh data in pivot tables lcoated in separate tabs?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I refresh data in pivot tables lcoated in separate tabs? (https://www.excelbanter.com/excel-discussion-misc-queries/154553-how-can-i-refresh-data-pivot-tables-lcoated-separate-tabs.html)

DavidG

How can I refresh data in pivot tables lcoated in separate tabs?

I have one data table and have numerous worksheet tabs for each pivot table
accessing the table. I would like a way to refresh all of the pivot tables
without having to go into each tab refreshing the associated pivot table.
Any thoughts?

All times are GMT +1. The time now is 04:25 PM.