Output Data into Excel sheet/ retaining Excel Pivot tables and Graphs

[Arkouda]

Hi All

I'm running into an issue where my output file saves into a Excel sheet and I want to retain the Excel Pivot Table and Graphs. Everytime I run the command with new data it removes the pivot tables and I have to rebuild news ones

Is there a way where it just updates the sheet in the workbook and does not impact the pivot tables/graphs besides copying and pasting the data into another sheet - this is the error I get and removes the pivot table in the file when I execute the command. 

Any assistance is greatly appreciated

[grossal · Accepted solution]

Hi @Arkouda,

I have just tested it and it seems like it's working if the Pivot-Table and Diagram is on another sheet and just referencing the original sheet. I still get a message but the pivot and graphs update just fine and aren't removed.

I have build a minimal workflow and two Excel files to test this.

I'll attach everything for you including the Excel files and you can see how it works. I think the key is to choose the option "Overwrite Sheet or Range" in the output and dropping and recreating the sheet.

Everything attached. Let me know what you think.

Best

Alex