Excel bug?: Graphics won't show after opening 100 Recordsets
 

We produce a number of Excel Add-ins that get loaded just after Excel
opens.
We have a recurring bug, which is that after loading our Add-ins, Excel
will not show the graphics in any file. They are still there but the
line style has been set to invisible (I think).
We have a work-around, which is to show a graphic (any graphic) before
loading our Add-Ins.

However, I have now managed to isolate the problem and reproduce it in
a workbook:
1) Open a workbook and run a macro that opens databases and Recordsets
(about 100 Recordsets)
2) Now open a file containing a graphic - they do not show
3) Close the recordsets and look at the graphic again - now they are
OK.

Is this a known problem? It didn't happen with Excel 2000 or earlier
but happens with Excel 2003.

I have sample code and a database to reproduce the problem if anyone is
interested.

Excel bug?: Graphics won't show after opening 100 Recordsets
 

Have not experienced this but curious how big your recordsets are and how
much memory you are using. Perhaps you are short on memory and this is
affecting the display of the graphics (Excel may suppress them when memory is
low since they also take memory).
--
- K Dales


" wrote:

We produce a number of Excel Add-ins that get loaded just after Excel
opens.
We have a recurring bug, which is that after loading our Add-ins, Excel
will not show the graphics in any file. They are still there but the
line style has been set to invisible (I think).
We have a work-around, which is to show a graphic (any graphic) before
loading our Add-Ins.

However, I have now managed to isolate the problem and reproduce it in
a workbook:
1) Open a workbook and run a macro that opens databases and Recordsets
(about 100 Recordsets)
2) Now open a file containing a graphic - they do not show
3) Close the recordsets and look at the graphic again - now they are
OK.

Is this a known problem? It didn't happen with Excel 2000 or earlier
but happens with Excel 2003.

I have sample code and a database to reproduce the problem if anyone is
interested.