I have a VB6 application that creates reports in Excel using Excel
templates. I retrieve data from a SQL Server database, populate certain
ranges in the Excel workbook which, in turn, supplies the data for the
chart. This all works fine. Infrequently, when a user creates a report,
the chart(s) will disappear when they close and reopen the file and
even when the user is clicking on different tabs in the Excel workbook
(without saving, closing an opening). I know this sounds bizarre - I am
totally perplexed and have been unable to reproduce this behavior.