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.