cannot edit and save
 

hi,

i am using excel 2000. i cannot edit and save a existing file.
the file is not protected,not read only and not shared.
when i open the file, a Microsoft excel window appear saying "File is
locked. In order to save changes to the file, you can either close the file
before making any changes and then re-open it, use Save As (File menu) to
save the file using another filename, or turn off Shared Workbooks and then
save the file."
i try to clear the checkbox on the format cellsprotectionLocked
but still when i click save a window appear saying "Document not saved"

please help

jp

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 Tue, 8 Feb 2005 11:26:02 +0800, "jp" wrote:

hi,

i am using excel 2000. i cannot edit and save a existing file.
the file is not protected,not read only and not shared.
when i open the file, a Microsoft excel window appear saying "File is
locked. In order to save changes to the file, you can either close the file
before making any changes and then re-open it, use Save As (File menu) to
save the file using another filename, or turn off Shared Workbooks and then
save the file."
i try to clear the checkbox on the format cellsprotectionLocked
but still when i click save a window appear saying "Document not saved"

please help