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.

You say you can't replicate it - have you observed it yourself or are you
relying on the user's report? Are you sure your user understands all the
possible ways portions of spreadsheets might be hidden: rows/columns somehow
might be getting hidden, or user might scroll away from used range on sheet,
etc?

If you have verified this in person or you know your user is reporting
reliably, I can't figure out what would make this happen - is there anything
else unusual that happens when the charts disappear or does it just seem
random?
--
- K Dales


" wrote:

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.

I'm relying on the user's report, but she sent me a sample of the
problem. The data for the chart is still in the sheet and not hidden
and the chart is completely missing.