I have an Excel 2007 workbook with some charts defined. I Load() the workbook, make a few changes, and then save it to the same file. When I open the workbook, the charts are not preserved.
In fact, if I just Load()/Save(), the charts are gone. Is this a known issue? Is there a workaround?
I upgraded to 11.1. The charts are now preserved after loading/saving, but my embedded picture is getting distorted. The picture is mostly black, and the image the picture displays is shrunk to the upper left hand corner.
Any ideas why this would happen?
ok. Thanks. I'll give that a try.
Round-trip support for charts was added as a bug fix in versions 9.2 and later. The fix was released on 12/20/2010. If you are using 9.2 or later and you upgrade to the latest SR, it should preserve the charts correctly.