Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel File says locked by My User ID - Can't Save
I left an Excel document open and unactive last night. I made some changes
this morning and when I went to save the file it told me that the file was locked by my user id. I rebooted my computer but it is still giving me this error - telling me I have to rename my file and save that way. How can I unlock? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel File says locked by My User ID - Can't Save
Excel stores a *.tmp copy 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 in use. You don't say that you had a crash but I would still try a couple of steps before re-naming the file, which would not be that difficult by the way. 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 other than copying the data to a new workbook. Gord Dibben Excel MVP On Fri, 23 Feb 2007 07:51:13 -0800, kristen0316 wrote: I left an Excel document open and unactive last night. I made some changes this morning and when I went to save the file it told me that the file was locked by my user id. I rebooted my computer but it is still giving me this error - telling me I have to rename my file and save that way. How can I unlock? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User defined file name on save | Excel Discussion (Misc queries) | |||
Can't save excel file. The message reads "File is locked" Why is t | Excel Discussion (Misc queries) | |||
User cannot save excel file in workbook | Excel Worksheet Functions | |||
excel locked by another user=myself | Setting up and Configuration of Excel | |||
File is locked for Editing by user problem | Excel Discussion (Misc queries) |