Refreshing Pivot Tables
I have one set of data and several pivot tables created using this data all
in the same workbook (each pivot table has its own tab) When refreshing the pivot tables I need to be able to refresh only one pivot table at a time, and the problem is that sometimes several pivot tables are updated after refreshing only one. This is needed because some of the pivot tables contain information that is updated only quarterly, yearly, etc. How do I ensure that all the pivot tables are set up correctly so that only one is refreshed at a time? |
Refreshing Pivot Tables
If you created the pivot tables by copying an existing pivot table,
they're based on the same pivot cache, and that's what you're refreshing. To create a different pivot cache for a pivot table: Right-click a cell in the pivot table, and choose PivotTable Wizard Click the Back button For the data range, change the last row so it's one row up. For example, if the current range is A1:M500, change it to A1:M499 Click Finish The pivot table will now have a separate pivot cache. Go back into the PivotTable Wizard, and change the data range to its previous setting, and click Finish. Lisa wrote: I have one set of data and several pivot tables created using this data all in the same workbook (each pivot table has its own tab) When refreshing the pivot tables I need to be able to refresh only one pivot table at a time, and the problem is that sometimes several pivot tables are updated after refreshing only one. This is needed because some of the pivot tables contain information that is updated only quarterly, yearly, etc. How do I ensure that all the pivot tables are set up correctly so that only one is refreshed at a time? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Refreshing Pivot Tables
Aha! Thank you very much!
"Debra Dalgleish" wrote: If you created the pivot tables by copying an existing pivot table, they're based on the same pivot cache, and that's what you're refreshing. To create a different pivot cache for a pivot table: Right-click a cell in the pivot table, and choose PivotTable Wizard Click the Back button For the data range, change the last row so it's one row up. For example, if the current range is A1:M500, change it to A1:M499 Click Finish The pivot table will now have a separate pivot cache. Go back into the PivotTable Wizard, and change the data range to its previous setting, and click Finish. Lisa wrote: I have one set of data and several pivot tables created using this data all in the same workbook (each pivot table has its own tab) When refreshing the pivot tables I need to be able to refresh only one pivot table at a time, and the problem is that sometimes several pivot tables are updated after refreshing only one. This is needed because some of the pivot tables contain information that is updated only quarterly, yearly, etc. How do I ensure that all the pivot tables are set up correctly so that only one is refreshed at a time? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 09:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com