Refreshing Pivot Tables

L

Lisa

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?
 
D

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.
 
L

Lisa

Aha! Thank you very much!

Debra Dalgleish said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top