I had the described error after the battery on my laptop when US. when
restarted, the spreadsheet was locked and marked as read only. I trie
the tips about deleting the temp versions, but could not find th
files. In the end I
Used AltCNTLDEL to kill off a rogue Excel process which had appeare
from somewhere. This allowed me into the spreadsheet however when I ra
it, I got the disconnected error (I have forgotten number and canno
recreate)
Next I made sure that all Excel sessions were closed (AltCNTLDEL) an
then reopened the spreadsheet disabling macros on the way in
Next I went into the
VB editor and exported all modules and userforms
Then exited
Next create a new sheet and import each of the entities to create th
application.
It took a few minutes to do, but all now seems well
--
Message posted from
http://www.ExcelForum.com