This File Is Locked Try the Command Again Later

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 proverb my file is locked for editing by "username". Why did I get this error? Afterward researching many solutions online, I am stumped and hope someone tin can help effigy this out.

As a frequent user of Excel application, you are spring to face errors like this. You do not accept to be panic if you lot incur such an editing error as it is common with Excel files and it tin can be fixed.

Keep reading this commodity as information technology explains why the excel file is locked for editing and shows how to fix this fault. Additionally, you can acquire 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 y'all know the causes for Excel file being locked for editing. There are lots of causes can trigger this type of mistake:

• File in use or locked for editing fault occurs when Excel fails to close properly, therefore, failing to save the file accordingly.

• The file could be opened by some other user when open in a shared network. In this case, you can merely open in Read-But fashion 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 mistake 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 information technology to releases the lock on the file. Alternatively, you tin can ask for edit permissions on the file or wait for the file to be closed by the other user.

If yous are not successful so here is a simple guide to accessing an excel file locked for editing.

Pace 1: Keenly note the file proper noun and the file path. To begin, launch the "Run" dialogue box by simultaneously holding the "Windows" central and pressing "R".

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

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

Stride 4: On the "Select the figurer you want the snap-in to manage" prompt, select the "Local computer" choice if you are logged in on the server or "Some other computer" if you are logged in at a different calculator. Search for the file location from this window.

Step 5: Proceed to select "Open Files" and click "OK".

Step 6: Finally, expand the "Open up 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 yous tin can edit the excel file having asunder the user who had information technology open up. Exit Excel and open up the file afresh to edit.

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

Having known how to fix the error, exist sure of how to avoid information technology side by side time. Using these tips, you lot are costless to work on your files across multiple users simultaneously.

Tip 1. Use Excel Version That Supports Co-authoring

Utilize the Excel version that supports co-authoring such as Excel for the spider web, Excel for Android, Excel for iOS, Excel for Office 356 and Excel for Role 365 for Mac.

Even so, the concluding two versions crave y'all to sign in to an Office account with an Office 365 subscription. For best co-authoring experience, y'all are advised to all use Excel Online.

Tip 2. Upload the File to Deject

SharePoint, OneDrive for Business or I Drive serve the best for co-authoring and easy accessibility. As a result, there is no "locked". Notwithstanding, co-authoring is not supported on deject locations, local folders, server paths and SharePoint On-Premises sites.

Tip iii. Check the File Formats

Yous 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 up 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 Every bit options and select the .xlsx, .xlsm, or .xlsb formats equally well.

Tip 4. Check One Drive Sync App

For One Drive sync app users, ensure it's the latest version for each user and non paused at whatsoever given fourth dimension.

Tip 5. Go Rid of Unsupported Features

Finally, in case there is a feature not supported by co-authoring, there volition be the "locked" error. Therefore, y'all will accept to turn 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 to a higher place solutions didn't fix the trouble for you? There is a possibility that your Excel file is locked for editing with a password. You probably prepare a password but forgot it or set information technology by a co-author without your knowledge. There is a definite solution also.

Passper for Excel can remove all editing restrictions on your worksheet/workbooks without losing or affecting your original data. The plan 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 plan.

Some of import features of Passper for Excel are listed beneath:

All editing and formatting restrictions on your Excel worksheets and workbooks tin exist removed within seconds.

The advanced applied science guarantees a 100% success rate.

The program is elementary to utilise. Unlock your locked for editing Excel file in simply 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 figurer.

Free Download for Win 10/viii.1/8/7/XP

Step 1 Click the "Remove Restrictions" option on the homepage.

Step two Upload the password-protected Excel file to the software by clicking the "Select a File" push button.

Pace 3 Click on "Remove" to offset the process. Just within seconds, the restrictions volition be removed.

In gild to help yous have an intuitive agreement of the whole process, you can watch the video guide beneath:

mirandamartur.blogspot.com

Source: https://passper.imyfone.com/excel/excel-file-locked-for-editing/