This File Is Locked Try the Command Again Later Excel

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 maxim my file is locked for editing past "username". Why did I get this mistake? Later on researching many solutions online, I am stumped and hope someone tin can help figure this out.

Equally a frequent user of Excel application, you are bound to face errors like this. You practice not have to be panic if you incur such an editing error as it is common with Excel files and information technology can exist stock-still.

Go on reading this article as it explains why the excel file is locked for editing and shows how to fix this error. Additionally, you tin can learn how to avoid this fault next time.

Role i: 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 shut 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, yous can only open in Read-Only mode and receive a notification when the file is set 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 besides trigger the error "filename.xlsx is locked for editing by "username"".

Part 2: How to Set up Excel File is Locked for Editing

This fault can be easily solved. Before proceeding to the guide below ensure the Excel file is closed on all devices. In case the mistake persists, close the file for a while and reopen information technology to releases the lock on the file. Alternatively, you tin ask for edit permissions on the file or expect for the file to exist closed past the other user.

If you are not successful then here is a unproblematic guide to accessing an excel file locked for editing.

Step 1: Keenly annotation the file name and the file path. To begin, launch the "Run" dialogue box by simultaneously holding the "Windows" primal and pressing "R".

Step 2: Search for the Microsoft Management Panel past inputting "MMC" on the search bar and choose "File" then "Add/Remove Snap-in".

Footstep 3: Select "Shared Folders" in the list of "Bachelor Snap-ins" and click "Add" to add together information technology to the "Selected snap-ins" list.

shared folders in microsoft management console

Step iv: On the "Select the computer yous want the snap-in to manage" prompt, select the "Local computer" selection if you lot are logged in on the server or "Another calculator" if you are logged in at a dissimilar computer. Search for the file location from this window.

Step 5: Go on to select "Open up Files" and click "OK".

Step 6: Finally, aggrandize the "Open Files" listing, sort the list preferably by author/user proper noun to locate the file. Right-click on the file and select "Shut Open file" from the options.

Now you can edit the excel file having asunder the user who had it open. Leave Excel and open the file afresh to edit.

Function 3: How to Avoid the State of affairs "Excel File Locked for Editing"

Having known how to fix the error, be certain of how to avert it adjacent time. Using these tips, you are complimentary to piece of work on your files across multiple users simultaneously.

Tip 1. Utilize Excel Version That Supports Co-authoring

Employ 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 Part 365 for Mac.

All the same, the last two versions crave you to sign in to an Function account with an Office 365 subscription. For best co-authoring experience, you are advised to all utilise Excel Online.

Tip ii. Upload the File to Cloud

SharePoint, OneDrive for Concern or One Drive serve the best for co-authoring and easy accessibility. Equally a result, there is no "locked". However, co-authoring is not supported on cloud locations, local folders, server paths and SharePoint On-Bounds sites.

Tip three. Check the File Formats

You must consider file formats for co-authoring to be sure its uniform 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>Salvage As>Browse>Save as type and select the above formats.
For Mac users click the File, Salve Equally options and select the .xlsx, .xlsm, or .xlsb formats equally well.

Tip 4. Check One Drive Sync App

For 1 Bulldoze sync app users, ensure it's the latest version for each user and not paused at any given fourth dimension.

Tip 5. Get Rid of Unsupported Features

Finally, in instance there is a feature not supported past co-authoring, in that location will be the "locked" error. Therefore, y'all will have to plough off the Shared Workbook characteristic 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? At that place is a possibility that your Excel file is locked for editing with a password. Yous probably set a password only forgot it or prepare it past a co-author without your knowledge. There is a definite solution equally well.

Passper for Excel can remove all editing restrictions on your worksheet/workbooks without losing or affecting your original information. The plan is innovatively designed past iMyFone team, which is trusted and recommended past many reputable review sites like Macworld, PCWorld, techradar, Cult of Mac, and etc. Therefore, it'southward completely secure to use this program.