I created Excel templates that contain tabular data and charts (pie, bar,
line mostly). The charts are populated with data I extract from a (SQL
Server) database and then load into pre-defined cell ranges. The users run a
VB6 application to generate the Excel reports. The issue I am having is that
users report that once the Excel file is created, the charts disappear when
the file is reopened. I have seen this result first hand as well. The data
that supports the chart is still there, but the charts themseleves disappear.
I actually recreated the template from scratch thiniing that the .XLT file
might have gotten corrupted somehow. This seemed to resolve the problem, but
now the issue has surfaced again. I did an exhaustive search of the web and
was unable to find anyone with the same or a similar problem. Users are
running Windows 2000 (SP4) and Excel 2000.
--
Dave G