ExcelBanter - pivot cash

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - pivot cash (https://www.excelbanter.com/excel-programming/380024-pivot-cash.html)

Erik Creyghton[_3_]

pivot cash

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

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

All times are GMT +1. The time now is 03:15 AM.