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?