Hello
Can you please tell me if there is any possibility in Excel 2007, when updating a pivot report the pivot chart would be also updated?
I have attached 2 Excel files: Erzeuge Berichte.xlsm and Ergebnis Vorlage LO.xlsx
Erzeuge Berichte.xlsm which includes a macro.
The macro sets a filter for all Pivot Tables in page Übersicht.
After Übersicht has been updated and copied to a sheet called (e.g. SVB).
Then Übersicht is updated with an other filter and copied to sheet HVB.
In the resulting sheet the Pivot-Tables have their own data according to the filters, but the Chart all refer to page Übersicht. So what can I do in order to update the pivot charts references.
Can you please take a look at the Excel files and tell me what can I do?
Thank you very much
Bookmarks