Refresh multiple pivot tables
I have created numerous pivot tables from my original using the PivotTable
and PivotChart Wizard. I selected "Another PivotTable report or PivotChart Report" when asked "Where is the data that you want to analyze." However, when I update the data and refresh the original, my data disappears on all the tables created from this method. By using the same pivot cache for multiple PivotTables, refreshing one table is suppose to refresh all tables. If there a way for all my pivot tables to refresh upon refreshing the original? |
All times are GMT +1. The time now is 06:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com