Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file in use when it's not
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 "Keith" wrote in message ... |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? | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
double click excel file on the desktop excel opens but not file? | Excel Discussion (Misc queries) | |||
Excel 2003: doubleclick on file opens Excel window, not file. | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Worksheet Functions | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Discussion (Misc queries) |