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?
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.
ok. Thanks. I'll give that a try.