Message -- Worksheet xls. is locked for editing. What is this?

G

gman

I cannot view or change the data in my worksheet because I am getting this
message. Why, and how do I unlock it?

Thanks for your help.

gman
 
G

Gord Dibben

gman

Has someone else got the file open?

If not...........

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 locked for editing.

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
 
G

gman

Hi, Gord,

Thanks for reply. I realized that sometimes it was because the file was
already open, while at other times I could find no reason for the message.
Also, after I received the message and then closed a document that was open,
another message would pop up stating the document was now available for
editing. If I click cancel in that message box it hangs up the computer.

So, I think I understand why at times I get the message.

gman
 
Top