Hello all -
I have created a Dashboard in Powerpivot for Excel which has multiple charts with multiple slicers.
I need to update my dashboard on a monthly basis, so this will require me to upload (refresh) new data into my powerpivot workbook.
When I upload the new data, this will most likely break the existing connections I have linked and will also break all the formatting I have created on my individual charts, which will require the painstaking process of re-creating my charts.
Once I re-establish my connections in the workbook, is there a way to preserve the chart formatting so I can import the new data into the pivot charts without impacting the charts?
I am fairly new to Powerpivot so if there is a simpler process for updating my source data monthly without having to recreate my dashboard each month, I'd really appreciate the help.
Thanks so much,
Judy