View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] awaters@linnhoffmarch.com[_2_] is offline
external usenet poster
 
Posts: 9
Default 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.