![]() |
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. |
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