My excel file is locked for editing. How do I get it opened.
 

While working on an excel worksheet, somehow the file went away. When I
tried to open it again, I got a message box "File in Use" with a message that
the file is locked for editing. Can't open it. Help if you can. Thanks
David

My excel file is locked for editing. How do I get it opened.
 

try closing the 1st file you opened. make sure you have the file sized at a
full page before you close the file
"DaveyOLostWages" wrote:

While working on an excel worksheet, somehow the file went away. When I
tried to open it again, I got a message box "File in Use" with a message that
the file is locked for editing. Can't open it. Help if you can. Thanks
David

My excel file is locked for editing. How do I get it opened.
 

Excel stores in Windows\Temp(win98) folder a copy(s) of any file that is open.

Sometimes this *.tmp file is not deleted from the Temp folder when you close
out Excel(maybe a crash of Excel?) or the file, so Excel thinks it is still
open and in use.

You can try a re-boot and see if that clears it up. If not, after a re-boot,
clear out your Windows\Temp folder.

If using WinXP your Temp folder would be under user.......

Documents and Settings\User\Local Settings\Temp

If on a network, re-booting the server may be the only solution.


Gord Dibben Excel MVP


On Sat, 29 Jul 2006 19:13:01 -0700, DaveyOLostWages
wrote:

While working on an excel worksheet, somehow the file went away. When I
tried to open it again, I got a message box "File in Use" with a message that
the file is locked for editing. Can't open it. Help if you can. Thanks
David

Gord Dibben MS Excel MVP