Maybe...
http://contextures.com/xlfaqApp.html#ReadOnly
or
http://contextures.com/xlfaqApp.html#AlreadyOpen
Both from Debra Dalgleish's site.
Keith wrote:
I have an Excel file that the whole company accesses. Yesterday it told me
that it was in use by someone so I could only open it in Read Only mode. The
person in question did not have it open.
I left it over night to clear, but this morning it now says it's in use by
me when I try to open it.
I decided to delete the file and restore it from a copy I have, but when I
try to delete it I get a message saying it can't find the file. I have tried
to delete it using both Windows Explorer and DOS prompt. Both show the file
as being there, but both still say that the file can't be found when I try to
delete it.
How can I get rid of this file that doesnt exist, but I can open in Read
Only mode?
--
Dave Peterson