Refreshing Pivot Tables

[Guest]

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]

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.

 

[Guest]

Aha! Thank you very much!

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.