View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Keith Keith is offline
external usenet poster
 
Posts: 262
Default Excel file in use when it's not

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?