Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) |