VBA bug? spreadsheet fails to open...HEEEELLPPPP!!!!
Posted by mike on June 28, 2001 6:18 PM
Ok...this has been troubling me for sometime, and I'm hoping someone can help.
I have a spreadsheet that FREQUENTLY becomes corrupted and will not open. I save backup copies, but because they often corrupt too, I lose work.
There is no error message...the 'loading' status bar at the bottom of excel just stops halfway, and the excel workspace displays blank white. The sheet does not show up in 'windows', and can be accessed or moved...it's like excel starts to open it and then decides not too!
I have a few things that could conceivably be causing this, but can't figure out what it is
1)Qlink - a DDE from quote.com, for importing stock quotes to excel
2)a lot of macros, including 'ontime' loops, custom pop-ups, and dynamically created imports of HTML into the workbook...
Anyone ever seen this problem before? Any idea how I can stop it? I am going insane losing copy after copy of this workbook!!!