Excel file in use when it's not

[Guest]

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 doesn’t exist, but I can open in Read
Only mode?

 

[Dave Peterson]

Maybe...

http://contextures.com/xlfaqApp.html#ReadOnly
or
http://contextures.com/xlfaqApp.html#AlreadyOpen

Both from Debra Dalgleish's site.

 

[Jim Rech]

I think you have to involve a network admin. It sounds as if the file was
not closed properly and the network has it marked as in use. An admin
should be able to override that.

--
Jim
|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 doesn't exist, but I can open in Read
| Only mode?
|