Office 2016 This File Is Locked Try the Command Again Later

I am using Excel 2010 on Win vii and I met a problem. I was trying to open an Excel file but got a bulletin saying my file is locked for editing by "username". Why did I get this fault? After researching many solutions online, I am stumped and hope someone can assist effigy this out.

As a frequent user of Excel application, you lot are bound to face errors like this. You do not have to exist panic if y'all incur such an editing fault every bit it is common with Excel files and information technology tin exist fixed.

Go on reading this article equally it explains why the excel file is locked for editing and shows how to fix this error. Additionally, you tin acquire how to avoid this fault next fourth dimension.

Role i: Why is the Excel File Locked for Editing?

It will exist easy to handle this problem if you lot know the causes for Excel file being locked for editing. At that place are lots of causes can trigger this blazon of fault:

• File in apply or locked for editing error occurs when Excel fails to close properly, therefore, declining to save the file accordingly.

• The file could be opened by some other user when open in a shared network. In this example, you tin can but open up in Read-Only mode and receive a notification when the file is ready for editing.

• Sometimes, Microsoft Part may create a temporary file for your Excel, which has "~$" followed by the name of your Excel file. This will likewise trigger the error "filename.xlsx is locked for editing by "username"".

Role two: How to Ready Excel File is Locked for Editing

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

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

Stride 1: Keenly annotation the file proper name and the file path. To brainstorm, launch the "Run" dialogue box by simultaneously property the "Windows" primal and pressing "R".

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

Pace three: Select "Shared Folders" in the list of "Available Snap-ins" and click "Add" to add information technology to the "Selected snap-ins" list.

Step 4: On the "Select the computer you want the snap-in to manage" prompt, select the "Local reckoner" option if y'all are logged in on the server or "Another computer" if y'all are logged in at a different figurer. Search for the file location from this window.

Step 5: Go along 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. Correct-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 up. Exit Excel and open the file afresh to edit.

Function 3: How to Avoid the Situation "Excel File Locked for Editing"

Having known how to fix the fault, be certain of how to avert it next time. Using these tips, you are gratis to work on your files across multiple users simultaneously.

Tip 1. Apply 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 Function 365 for Mac.

However, the last two versions crave you to sign in to an Office account with an Office 365 subscription. For all-time co-authoring feel, yous are advised to all use Excel Online.

Tip ii. Upload the File to Cloud

SharePoint, OneDrive for Business organization or One Drive serve the best for co-authoring and easy accessibility. Equally a upshot, there is no "locked". Even so, co-authoring is not supported on deject locations, local folders, server paths and SharePoint On-Bounds sites.

Tip 3. Check the File Formats

You must consider file formats for co-authoring to be certain 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 Every bit>Browse>Save as type and select the higher up formats.

• For Mac users click the File, Salvage Equally options and select the .xlsx, .xlsm, or .xlsb formats besides.

Tip iv. Check One Drive Sync App

For Ane Drive sync app users, ensure information technology's the latest version for each user and not paused at whatever given time.

Tip 5. Get Rid of Unsupported Features

Finally, in case there is a feature non supported by co-authoring, at that place will exist the "locked" error. Therefore, you lot will have to plow 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 Countersign?

The to a higher place solutions didn't set the problem for y'all? At that place is a possibility that your Excel file is locked for editing with a password. Y'all probably set a password simply forgot it or set it by a co-author without your noesis. 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 past 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 important features of Passper for Excel are listed beneath:

All editing and formatting restrictions on your Excel worksheets and workbooks can be removed inside seconds.

The advanced engineering science guarantees a 100% success rate.

The programme is uncomplicated to use. Unlock your locked for editing Excel file in only 3 steps.

File types similar .xls, .xlsx, .xlsm, .xltm, .xlsb and etc are supported past this tool.

Hither is a simple procedure to follow to remove the restrictions from Excel Worksheet/Workbook.

Download and install Passper for Excel software and launch information technology on your figurer.

Free Download for Win x/eight.1/8/7/XP

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

Step ii Upload the password-protected Excel file to the software past clicking the "Select a File" button.

Pace three Click on "Remove" to start the process. Just inside seconds, the restrictions will be removed.

In order to assistance you lot take an intuitive understanding of the whole process, y'all can watch the video guide below:

harterannis1952.blogspot.com

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

Share this post