The File Is Locked. Try the Command Again Later

Are you lot unable to edit your Excel workbook due to an error message "The document is locked for editing by some other user"?

If you also desire to solve this Excel file locked by some other user how to unlock mystery then yous are on the correct folio. As today through this post, I am gonna share some piece of cake fixes to resolve this Excel file is locked for editing by another user fault.

Earlier that let's find out why "The document is locked for editing by some other user" error is appearing while trying to edit the Excel spreadsheet.

How Word And Excel Files Become Non-Editable?

This error is not express to the Excel file, MS Discussion users are as well facing File is locked for editing by some other user error message.

There are lots of causes that can trigger this type of fault and forestall the user from editing Excel or give-and-take file.

If you haven't quit the Excel file properly then the Excel application becomes unable to delete the owner file and hence when the user tries to open/edit the Excel file then they get "The document is locked for editing by another user" error message.

If the Excel file a Word file saved on the server so it is possible that the same file is getting used by another person at the same time.

Microsoft's office creates a temporary ownership file for their Excel and Word, this file is present in the location of the certificate, having "~$" followed past the name of the file. For Example: The filename of "myfile.doc" volition have an ownership file name "~$myfile.doc", both the files are created on newmisserver\public.

The file likewise contains the name of the owner who is currently editing the document. You tin see the file on newmisserver\public from a reckoner, but on a Mac, you lot can't encounter this file.

To extract information from corrupt Excel file, we recommend this tool:

This software will prevent Excel workbook data such every bit BI data, financial reports & other analytical information from abuse and data loss. With this software yous can rebuild decadent Excel files and restore every single visual representation & dataset to its original, intact state in three easy steps:

1. Download Excel File Repair Tool rated Splendid past Softpedia, Softonic & CNET.
2. Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.
3. Preview the repaired files and click Save File to save the files at desired location.

Why Is My Excel File Locked For Editing?

There are various causes that can trigger this type of Excel File Locked For Editing issues. Some of the common reasons for "The certificate is locked for editing by some other user" mistake are as follows:

• Microsoft Excel isn't closed properly and, therefore, didn't erase the owner file.
• The second request of the Excel file is agile in the background with the doc already open.
• The Excel doc is shared over a network, and used past whatever other user.

Sometimes you may also go the error message saying that:

File in Employ – {filename] is locked for editing past {username}. Open up Read-Only" or click "Notify to receive a notification when the document is no longer in use.

Screenshot of the error:

How To Fix Microsoft Excel File Locked For Editing?

In order to solve Excel file in use result, we volition disconnect the user from the file, and let another user to go the complete accessibility. So follow all the below-given solutions.

Method one# Disconnect User From The Opened Excel File And Unlock It

1: First you take to note down the path to the file, and the file name.

2: Open up the run dialogue box, press the Windows Key + R from your keyboard to open upwards theRun dialog box.

3: In the run dialogue box, type "mmc" and and then hit the Enter fundamental to open up up the "Microsoft Management Panel".

4: Choose the "File" > "Add/Remove Snap-in".

5: From the list of "Available snap-ins", choose the "Shared Folders" and and so choose "Add together" to add it to the "Selected snap-ins" list.

6: Another box will appear request you lot to "Select the figurer you want the snap-in to manage". In case you are logged in on the server where the contaminated Excel file is present, so select "Local computer". But if you are using a dissimilar organization, then select the "Another computer", then type the server where the Excel file stored.

seven: Now, in the view department, choose the "Open Files".

eight: Choose the "OK"

9: Click on the "Open Files" to expand it.

10: Yous can sort the entire list according to your demand and and then search the file in the list. Later it, correct-click the file and, select "Close Open File"

Method 2# Quit All The Instances Of Excel

Follow the below-mentioned steps to finish your PC from all the opened instances of Excel. This ultimately works in resolving Excel file in use error.

• Effort to save your ongoing piece of work, after that exit from all programs.
• Press the CTRL+ALT+DELETE push button from your keyboard. This will open the dialog box of Windows Security.
• Hitting the Task Manager and then get to the Processestab.
• Click Excel.exe, and then clickStop Process.

• In theTask Manager Warning dialog box, clickYes.
• If y'all are receiving locked for editing past another user or your program is non responding so click Stop Now.

• On theFile menu, tap to the Exit Chore Manager.

Method 3# Same File Is Editing By Some other User

If any other user is also working on the aforementioned excel file at the same time then you have the two options to perform. The offset one is, either yous can await till that person releases the file. And the second one is to make a copy of your Excel file and brand all the changes in this copied document.

 Or y'all tin can too switch to such an app that allows multiple authors to work on the file concurrently.

Note: If you are working on the same Excel file with multiple users, then ensure that all the users must exist using the aforementioned version of Excel which has well back up for co-authoring.

Method 4# Function App Already Executing In Background

If you are very much sure that your excel file is not shared on the network nor it is been edited past any other user. In that case, chances are loftier that instances of the Office app along with the opened file are already executing in the background.

Method 5# Cheque Your Excel Version Support Co-Authoring Or Not

To piece of work on the Excel file which is used by multiple users at the same time, make sure all the users are using Excel version which supports co-authoring.

If your excel version back up co-authoring than more than than one person tin can easily open and work on the file at the aforementioned time.  Apart from this, they can as well view other user'southward changes in just a few seconds.

Post-obit Excel application Versions well back up this co-authoring characteristic:

• Excel Mobile
• Excel for the web
• Excel for Android
• Excel for Microsoft 365 for Mac*
• Excel for iOS
• Excel for Microsoft 365*

Annotation: Excel 2019 version doesn't support this co-authoring feature.

This locked for editing by another user fault also encounters also when a unmarried user from the multiple users' grouping is using the Excel version which doesn't support this co-authoring.

If you are not sure nearly which Excel version they are using then encourage all to use Excel Online. This will facilities you with this co-authoring feature in the web browser only.

Method 6# Stick With These Excel File Formats

For Windows:

In spite of using the co-authoring feature in your Excel application if however you are getting the same locked for editing by another user error. At that fourth dimension, keenly cheque the file format in which this specific Excel file is been saved.

Make certain that your excel file must exist in the following .xlsx, .xlsm, or .xlsb format.

If information technology's non then, become to theFile >Save As >Browse >Save as type option. Afterwards that select any ane of the .xlsx, .xlsm, or .xlsb formats.

For Mac user:

Go to theFile >Save Equally… Option and so choose any one of the .xlsx, .xlsm, or .xlsb format.

Method 7# Remove Unsupported Features From The File

If still, y'all are getting this Excel file in utilise fault then the reason tin can be the unsupported Excel feature that doesn't work with co-authoring.

So for this, yous just need to ask one of your Excel file users to perform the following job.

The start option is to plow off the shared Excel workbook feature. If a snapshot is opened from SharePoint so it will open up your workbook automatically.

If these two solutions fail to work so try the following solutions.

Windows:

• If information technology's possible and so remove the countersign or restricted file access settings. For this just follow this path: File >Info >Protect Workbook selection. After that, y'all have to remove restricted access settings and passwords if it is applied.

• DisableRefresh information when opening file setting nowadays inside the pivot table and tables of the file. Choose the PivotTable or table, after that follow this path: Tabular array Tools Design >Refresh >Connection Properties. At present uncheck the Refresh data when opening file option.

• Inactivate the excel add together-in which causes this lock file issue. Choose the File >Options >Add together-Ins >Excel Add-ins >Go selection. Uncheck the add-in checkbox.

Conclusion

Now you must take got the perfect answer to your query Excel file locked by another user how to unlock.

If y'all successfully fixed this upshot with the help of the to a higher place-given steps then it'south good. Only if you are nevertheless unable to fix this issue or unable to follow the below-given steps due to lack of noesis then you can go with the automatic solution to repair MS Excel errors.

Download and install the Excel Repair Tool, and fix Excel editing bug with ease. This tool is very simple to use as you don't need any professional person skills to perform Excel recovery. It is recommended to employ this tool once and make your Excel file fault-free without doing anything manually.

We've already discussed several errors and tried to set up them, if you are new to our website and want to read our latest blogs so kindly visit:https://world wide web.repairmsexcel.com/web log

If you have whatever queries related to the Excel file so kindly contact usa in our social accounts like Facebook and Twitter.

* Free version of the product simply previews recoverable data.

Summary

Article Name

[Solved] Tutorial to Ready "Microsoft Excel File is Locked for Editing/in Use" Issue!

Description

Apply the given steps one past one to fix the "Microsoft Excel File is Locked for Editing/in Use" error without need of whatsoever professional person skill.

Author

Sandra Louis

Publisher Proper name

Repair MS Excel Blogs

Publisher Logo

Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Role, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to sympathise language is very impressive. When non writing, she loves unplanned travels.

davismuchat.blogspot.com

Source: https://www.repairmsexcel.com/blog/solved-microsoft-excel-file-is-locked-for-editing-in-use-issue