View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel file in use when it's not

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