Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want excel to show the first tab upon opening, not the second | Excel Discussion (Misc queries) | |||
graphics properties changes when opening Excel | Excel Discussion (Misc queries) | |||
HOW I CAN SHOW A DATA AS REFERENCE INTO A GRAPHICS? | Charts and Charting in Excel | |||
Problem displaying recordsets in Excel Format | Excel Discussion (Misc queries) | |||
How can I use 2 diff. recordsets without opening another db connec | Excel Programming |