Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
awaters@linnhoffmarch.com - 22 Mar 2006 10:24 GMT
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.
K Dales - 22 Mar 2006 13:37 GMT
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).
Signature

- K Dales

> We produce a number of Excel Add-ins that get loaded just after Excel
> opens.
[quoted text clipped - 17 lines]
> I have sample code and a database to reproduce the problem if anyone is
> interested.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.