Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Message -- Worksheet xls. is locked for editing. What is this?
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 |
#2
|
|||
|
|||
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 On Wed, 20 Apr 2005 16:31:06 -0700, "gman" wrote: 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 |
#3
|
|||
|
|||
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 "Gord Dibben" wrote: 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 On Wed, 20 Apr 2005 16:31:06 -0700, "gman" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
grand total column B from every worksheet in workbook | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |