Excel locked for editing by me but not open

06-15-2022, 02:41 PM Nội dung chính Show 1. Excel File is Locked for Editing By Another User – Single Owner Case 2. Shared Excel File is Locked for Editing By Another User How do I fix Excel locked for editing by another user? Why is my document locked for editing by me? How do I Unrestrict an Excel file for editing?

Competent Performer   Join Date: May 2019 Posts: 170

Quote: Originally Posted by zeref I am the only one who uses the computer and the file is stored locally and NOT on a server. I am NOT part of any work domain as it's my personal PC. When I open the Excel file, I get a message saying that the file is locked for editing by 'my name'. There is no owner file (~$doc.xlsx) and I even rebooted the machine and still the same issue. Wow, I've had this happen, but usually a reboot cures it. By reboot, you're doing a complete shutdown and a cold start? If not, give that a try. Wait until it's fully powered down. I like rollis13's suggestion of trying to open it in one of the open-source programs. I would also be curious as to whether you're first opening Excel, and then selecting and opening the file from within Excel, or clicking on the file in File Explorer. I would also suggest running the repair on Excel/Office in "Add or remove programs." We're on Office 365 and I've had to do this a few times. We also had an issue for a while from our IT guy installing 365 and not removing the old Office. Files would open if accessed from within the program, but when double clicked in File Explorer or on the desktop, they would appear to open but be invisible. Eliminating the other Office and running a repair cured this. You might right-mouse-click on your file and check out what your computer is offering under the open-ended "Open With..." line. I also had a problem after I tried to open an old WordPerfect file in Word. Apparently it tried unsuccessfully to load it and messed things up until I ran the repair. So is it possible you opened something non-Excel in Excel recently? Hope you are able to figure it out! Best regards, Ann

If you are unable to open or edit an Excel file due to “File is locked for editing by another user” error message, you will find below the steps to fix this issue in Microsoft Excel.

The File in Use and File is Locked for Editing error in Microsoft Excel can occur both if the file is being used by another user (in case of shared workbook) and also if the file is locked by yourself.

In case of Shared File, this error can occur if another user is working on the file or has left the file open on his/her computer.

If you are not sharing the file with anyone and still see “File is Locked for editing by another user” error message, you yourself are the other user.

So, let us go ahead and take a look at the steps to fix “File is Locked for Editing by another use” error, both in Shared and Single owner cases.

1. Excel File is Locked for Editing By Another User – Single Owner Case

When you open an Excel file, Microsoft Office creates a temporary ownership file and automatically deletes this file as soon as you close the Excel File.

However, sometimes the file does not close properly and the temporary ownership file remains in the memory, leading to “File in Use and File is Locked for editing” error in Excel.

The fix for this issue is to locate and delete the temporary ownership file from your computer.

1. Right-click on the Start button and click on File Explorer.

2. On the File Explorer screen, navigate to the location of the temporary ownership file having name ~$ and delete this file.

For example, if the Excel file that you want to open/Edit is example.xls, you will find a temporary ownership file having the name ~$example.com.

Once you delete the temporary ownership file, you will be able to open/edit your Excel File, without encountering “File is Locked for editing by another user” message.

2. Shared Excel File is Locked for Editing By Another User

If you are getting “File is Locked for Editing by another user” message in case of a Shared File, you can ask the other User to close the File or use the co-authoring feature in Excel.

However, if the other User has left the File open and is currently unavailable, you can follow the steps below to remotely close the file.

Note: You need to have Admin access to the server where the Excel file resides, in order to be able to remotely close open files on a network.

1. Note down the File Name and the Path to the Excel File.

2. Right-click on the Start button and click on RUN.

Note: You can also press Windows + R keys to bring up the Run command.

3. In Run Command window, type mmc and click on OK to bring up Microsoft Management Console.

4. On the next screen, click on File > Add/Remove Snap-in.

5. On the Add or Remove Snap-ins screen, select Shared Folders and click on the Add button.

6. On the next screen, select Another computer and click on the Browse button to locate the other computer on which the Excel File resides.

Once you find the Other computer, select Open Files option and click on the Finish button (See above image).

7. Back on the Add or Remove Snap-ins screen, click on OK to Add the Snap-in to manage Shared Files on another computer.

8. On the next screen, expand the list of Open Files > right-click on the Locked Excel File and click on Close Open File option.

Once you are able to remotely close the open Excel file, the other user will be removed from the File and you will be able to open the locked Excel file and make changes to it.

• How to Fix Microsoft Excel Not Responding Error in Windows 10
• How to Print to PDF or Save As PDF in Microsoft Excel

How do I fix Excel locked for editing by another user?

Why is my document locked for editing by me?

How do I Unrestrict an Excel file for editing?