If you have different pivot charts, you must have also created different
pivot tables. Somehow, those have created one or more additional pivot
caches, and don't use the original pivot cache.

There's sample code here that will change all the pivot tables to use
the same pivot cache.

http://www.contextures.com/xlPivot11.html


Pilou-bcn wrote:
Hello;
I am have trouble finding a solution about auto-refresh.
I have an XL file with all the data.
I created another file where my Pivots tables are. I have the auto-refresh
at opening selected.
In the Pivot workbook, I have a main pivot table and charts. Then I created
other Pivot charts that use the information from the initial one.
When I change the file source, only the main pivot table/chart get the data
refresh. All the other still display the data from the previous data sheet.
Could you please give me a hand on this please?
Thanks in advance.


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