ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Updating Pivot Tables (https://www.excelbanter.com/excel-programming/375741-updating-pivot-tables.html)

Oren

Updating Pivot Tables
 
I have about 20 pivot tables all based on the same pivot cache. If I update
the pivot cache (i.e. add 1000 rows) can I update all of the pivot tables
simultaneously. It is quite labor-intensive to update each pivot table
separately.

Tom Ogilvy

Updating Pivot Tables
 
Updating one updates them all in my experience.

--
Regards,
Tom Ogilvy



"Oren" wrote:

I have about 20 pivot tables all based on the same pivot cache. If I update
the pivot cache (i.e. add 1000 rows) can I update all of the pivot tables
simultaneously. It is quite labor-intensive to update each pivot table
separately.



All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com