Edit A Chart's XML

Apr 17, 2013 at 3:54 PM
Hi guys,

Is it possible to edit a chart's XML?

I have a worksheet named "Retailer Template" and it has 4 charts in it. My code replicates this worksheet over a number of times, and then it is deleted.

The problem is when the user tries to open the file, Excel 2010 shows up an error message saying that the file has unreadable content. I've been contemplating on this issue for almost a week now. And while I was debugging using breakpoints, I see in the chart's XML that it still has worksheet name references to the deleted template and not its own worksheet name.

I believe that the "unreadable content" Excel says originates in the chart's XML. Can there be a solution to this?


Thanks,