Note: If you are working on the same Excel file with multiple users, then ensure that all the users must be using the same version of Excel which has well support for co-authoring. Or you can also switch to such an app that allows multiple authors to work on the file concurrently. And the second one is to make a copy of your Excel file and make all the changes in this copied document. The first one is, either you can wait till that person releases the file. If any other user is also working on the same excel file at the same time then you have the two options to perform. Method 3# Same File Is Editing By Another User On the File menu, tap to the Exit Task Manager.
In the Task Manager Warning dialog box, click Yes.Click Excel.exe, and then click End Process.Hit the Task Manager and then go to the Processes tab.
This will open up the dialog box of Windows Security. Press the CTRL+ALT+DELETE button from your keyboard.Try to save your ongoing work, after that exit from all programs.This ultimately works in resolving Excel file in use error.
Method 2# Quit All The Instances Of Excelįollow the below-mentioned steps to terminate your PC from all the opened instances of Excel. After it, right-click the file and, select “ Close Open File” But if you are using a different system, then select the “ Another computer”, then type the server where the Excel file stored.ħ: Now, in the view section, choose the “ Open Files“.ĩ: Click on the “ Open Files” to expand it.ġ0: You can sort the entire list according to your need and then search the file in the list. In case you are logged in on the server where the contaminated Excel file is present, then select “ Local computer”. Method 1# Disconnect User From The Opened Excel File And Unlock Itġ: First you have to note down the path to the file, and the file name.Ģ: Open the run dialogue box, press the Windows Key + R from your keyboard to open up the Run dialog box.ģ: In the run dialogue box, type “ mmc” and then hit the Enter key to open up the “ Microsoft Management Console“.Ĥ: Choose the “ File” > “ Add/Remove Snap-in“.ĥ: From the list of “ Available snap-ins”, choose the “ Shared Folders” and then choose “ Add” to add it to the “ Selected snap-ins” list.Ħ: Another box will appear asking you to “ Select the computer you want the snap-in to manage“. In order to solve Excel file in use issue, we will disconnect the user from the file, and allow another user to get the complete accessibility.
How To Fix Microsoft Excel File Locked For Editing? Open Read-Only” or click “Notify to receive a notification when the document is no longer in use. Sometimes you may also get the error message saying that:įile in Use –. The Excel doc is shared over a network, and used by any other user.The second request of the Excel file is active in the background with the doc already open.Microsoft Excel isn’t closed properly and, therefore, didn’t erase the owner file.Some of the common reasons for “ The document is locked for editing by another user” error are as follows: There are various causes that can trigger this type of Excel File Locked For Editing issues. Preview the repaired files and click Save File to save the files at desired location.Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.