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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
try closing the 1st file you opened. make sure you have the file sized at a
full page before you close the file
 
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


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
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top