I am using Excel 2010 on Win 7 and I met a problem. I was trying to open an Excel file but got a message saying my file is locked for editing by "username". Why did I get this error? After researching many solutions online, I am stumped and hope someone can help figure this out.
As a frequent user of Excel application, you are bound to face errors like this. You do not have to be panic if you incur such an editing error as it is common with Excel files and it can be fixed.
Keep reading this article as it explains why the excel file is locked for editing and shows how to fix this error. Additionally, you can learn how to avoid this error next time.
Part 1: Why is the Excel File Locked for Editing?
It will be easy to handle this problem if you know the causes for Excel file being locked for editing. There are lots of causes can trigger this type of error:
File in use or locked for editing error occurs when Excel fails to close properly, therefore, failing to save the file accordingly.
The file could be opened by another user when open in a shared network. In this case, you can only open in Read-Only mode and receive a notification when the file is ready for editing.
Sometimes, Microsoft Office may create a temporary file for your Excel, which has "~$" followed by the name of your Excel file. This will also trigger the error "filename.xlsx is locked for editing by "username"".
Part 2: How to Fix Excel File is Locked for Editing
This error can be easily solved. Before proceeding to the guide below ensure the Excel file is closed on all devices. In case the error persists, close the file for a while and reopen it to releases the lock on the file. Alternatively, you can ask for edit permissions on the file or wait for the file to be closed by the other user.
If you are not successful then here is a simple guide to accessing an excel file locked for editing.
Step 1: Keenly note the file name and the file path. To begin, launch the "Run" dialogue box by simultaneously holding the "Windows" key and pressing "R".
Step 2: Search for the Microsoft Management Console by inputting "MMC" on the search bar and choose "File" and then "Add/Remove Snap-in".
Step 3: Select "Shared Folders" in the list of "Available Snap-ins" and click "Add" to add it to the "Selected snap-ins" list.
Step 4: On the "Select the computer you want the snap-in to manage" prompt, select the "Local computer" option if you are logged in on the server or "Another computer" if you are logged in at a different computer. Search for the file location from this window.
Step 5: Proceed to select "Open Files" and click "OK".
Step 6: Finally, expand the "Open Files" list, sort the list preferably by author/user name to locate the file. Right-click on the file and select "Close Open file" from the options.
Now you can edit the excel file having disconnected the user who had it open. Exit Excel and open the file afresh to edit.
Part 3: How to Avoid the Situation "Excel File Locked for Editing"
Having known how to fix the error, be sure of how to avoid it next time. Using these tips, you are free to work on your files across multiple users simultaneously.
Tip 1. Use Excel Version That Supports Co-authoring
Use the Excel version that supports co-authoring such as Excel for the web, Excel for Android, Excel for iOS, Excel for Office 356 and Excel for Office 365 for Mac.
However, the last two versions require you to sign in to an Office account with an Office 365 subscription. For best co-authoring experience, you are advised to all use Excel Online.
Tip 2. Upload the File to Cloud
SharePoint, OneDrive for Business or One Drive serve the best for co-authoring and easy accessibility. As a result, there is no "locked". However, co-authoring is not supported on cloud locations, local folders, server paths and SharePoint On-Premises sites.
Tip 3. Check the File Formats
You must consider file formats for co-authoring to be sure its compatible with all users. The recommended formats are .xlsx, .xlsm or .xlsb for Windows and Mac users.
To set the file format for Windows, click the File>Save As>Browse>Save as type and select the above formats.
For Mac users click the File, Save As options and select the .xlsx, .xlsm, or .xlsb formats as well.
Tip 4. Check One Drive Sync App
For One Drive sync app users, ensure it's the latest version for each user and not paused at any given time.
Tip 5. Get Rid of Unsupported Features
Finally, in case there is a feature not supported by co-authoring, there will be the "locked" error. Therefore, you will have to turn off the Shared Workbook feature and open the workbook instead of the snapshot from SharePoint.
Tip: What if Your Excel File is Locked for Editing with A Password?
The above solutions didn't fix the problem for you? There is a possibility that your Excel file is locked for editing with a password. You probably set a password but forgot it or set it by a co-author without your knowledge. There is a definite solution as well.
Passper for Excel can remove all editing restrictions on your worksheet/workbooks without losing or affecting your original data. The program is innovatively designed by iMyFone team, which is trusted and recommended by many reputable review sites like Macworld, PCWorld, techradar, Cult of Mac, and etc. Therefore, it's completely secure to use this program.
Some important features of Passper for Excel are listed below:
All editing and formatting restrictions on your Excel worksheets and workbooks can be removed within seconds.
The advanced technology guarantees a 100% success rate.
The program is simple to use. Unlock your locked for editing Excel file in just 3 steps.
File types like .xls, .xlsx, .xlsm, .xltm, .xlsb and etc are supported by this tool.
Here is a simple procedure to follow to remove the restrictions from Excel Worksheet/Workbook.
Download and install Passper for Excel software and launch it on your computer.
Step 1 Click the "Remove Restrictions" option on the homepage.
Step 2 Upload the password-protected Excel file to the software by clicking the "Select a File" button.
Step 3 Click on "Remove" to start the process. Just within seconds, the restrictions will be removed.
In order to help you have an intuitive understanding of the whole process, you can watch the video guide below: