Thread: pivot cash
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default pivot cash

If all the pivot tables use the same pivot cache, you can refresh one,
and all pivot tables will use the updated cache.

Erik Creyghton wrote:
I have many pivot tables sharing the same cash space. When I reload the
input range with a VBA routine do I have to refresh all pivot tables or is
it sufficient to refresh only one and all the others will follow ?
regards, Erik


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html