Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel File Locked
Hello,
When I open a certain Excel file, I receive a message to the effect that 'The file <filename is locked because it is being edited by <myname. Press Read Only or Notify.' Now the file, which I created and use myself, has never been shared, and every time I encounter this situation, I must use the 'Save As' command to save any changes to the file. How do I unlock the file? Suggestions are most welcome! |
#2
|
|||
|
|||
Hi
try clearing the TEMP directory, reboot your computer and try again -- Regards Frank Kabel Frankfurt, Germany "robot" schrieb im Newsbeitrag ... Hello, When I open a certain Excel file, I receive a message to the effect that 'The file <filename is locked because it is being edited by <myname. Press Read Only or Notify.' Now the file, which I created and use myself, has never been shared, and every time I encounter this situation, I must use the 'Save As' command to save any changes to the file. How do I unlock the file? Suggestions are most welcome! |
#3
|
|||
|
|||
Hi Frank,
Thank you for your reply. I heed your advice and try deleting temp files in my TEMP dir, and found that a file, namely ~dfd0a9.tmp, was created when I rename (no need to open!) my Excel file, and can't be deleted without a reboot. There must be something wrong with my system. :-( More suggestions are most welcome. "Frank Kabel" ¦b¶l¥ó ¤¤¼¶¼g... Hi try clearing the TEMP directory, reboot your computer and try again -- Regards Frank Kabel Frankfurt, Germany "robot" schrieb im Newsbeitrag ... Hello, When I open a certain Excel file, I receive a message to the effect that 'The file <filename is locked because it is being edited by <myname. Press Read Only or Notify.' Now the file, which I created and use myself, has never been shared, and every time I encounter this situation, I must use the 'Save As' command to save any changes to the file. How do I unlock the file? Suggestions are most welcome! |
#4
|
|||
|
|||
robot
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 Sun, 28 Nov 2004 23:00:44 +0800, "robot" wrote: Hi Frank, Thank you for your reply. I heed your advice and try deleting temp files in my TEMP dir, and found that a file, namely ~dfd0a9.tmp, was created when I rename (no need to open!) my Excel file, and can't be deleted without a reboot. There must be something wrong with my system. :-( More suggestions are most welcome. "Frank Kabel" ¦b¶l¥ó ¤¤¼¶¼g... Hi try clearing the TEMP directory, reboot your computer and try again -- Regards Frank Kabel Frankfurt, Germany "robot" schrieb im Newsbeitrag ... Hello, When I open a certain Excel file, I receive a message to the effect that 'The file <filename is locked because it is being edited by <myname. Press Read Only or Notify.' Now the file, which I created and use myself, has never been shared, and every time I encounter this situation, I must use the 'Save As' command to save any changes to the file. How do I unlock the file? Suggestions are most welcome! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel file locked for editing by 'my name' ! How do I unlock? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |