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
"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

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