Excel the File Is Locked Try 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 bulletin 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.

Equally a frequent user of Excel awarding, you are bound to face errors similar this. Y'all practise not have to exist panic if you incur such an editing error as it is common with Excel files and it tin be fixed.

Continue reading this commodity equally information technology explains why the excel file is locked for editing and shows how to fix this mistake. Additionally, you can learn how to avoid this mistake next time.

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

It will exist 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 mistake occurs when Excel fails to close properly, therefore, failing to save the file appropriately.

• The file could be opened by another user when open in a shared network. In this case, you tin can just open in Read-Merely manner and receive a notification when the file is set up 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 past "username"".

Function two: 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 instance 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 lot are non successful then here is a simple guide to accessing an excel file locked for editing.

Pace one: Keenly notation the file name and the file path. To begin, launch the "Run" dialogue box by simultaneously belongings the "Windows" key and pressing "R".

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

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

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

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

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

At present you can edit the excel file having disconnected the user who had it open. Go out Excel and open up the file anew to edit.

Part iii: How to Avert the Situation "Excel File Locked for Editing"

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

Tip 1. Use Excel Version That Supports Co-authoring

Use the Excel version that supports co-authoring such equally Excel for the spider web, Excel for Android, Excel for iOS, Excel for Office 356 and Excel for Function 365 for Mac.

Notwithstanding, the last two versions require y'all to sign in to an Part business relationship with an Role 365 subscription. For best co-authoring experience, you lot are advised to all use Excel Online.

Tip 2. Upload the File to Cloud

SharePoint, OneDrive for Business or One Bulldoze serve the best for co-authoring and piece of cake accessibility. As a outcome, there is no "locked". Still, 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 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>Salvage As>Browse>Salvage as type and select the above formats.

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

Tip four. Check Ane Drive Sync App

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

Tip 5. Get Rid of Unsupported Features

Finally, in case in that location is a characteristic non supported by co-authoring, in that location will exist the "locked" error. Therefore, you volition have to plough 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 Countersign?

The above solutions didn't gear up the problem for you? There is a possibility that your Excel file is locked for editing with a countersign. You lot probably set a password but forgot it or set information technology by a co-author without your knowledge. At that place 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 unproblematic to employ. 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 process 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 10/8.1/8/seven/XP

Footstep 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" button.

Footstep 3 Click on "Remove" to starting time the process. Just within seconds, the restrictions volition be removed.

In order to help you lot accept an intuitive understanding of the whole procedure, you can watch the video guide beneath:

steedresichey.blogspot.com

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

Share this post