Excel File is Locked For Modifying By One other Consumer

If you’re unable to open or edit an Excel file resulting from “File is locked for enhancing by one other consumer” error message, you’ll discover beneath the steps to repair this subject in Microsoft Excel.

Excel File is Locked for Modifying By One other Consumer

The File in Use and File is Locked for Modifying error in Microsoft Excel can happen each if the file is being utilized by one other consumer (in case of shared workbook) and in addition if the file is locked by your self.

In case of Shared File, this error can happen if one other consumer is engaged on the file or has left the file open on his/her pc.

If you’re not sharing the file with anybody and nonetheless see “File is Locked for enhancing by one other consumer” error message, you your self are the opposite consumer.

So, allow us to go forward and check out the steps to repair “File is Locked for Modifying by one other use” error, each in Shared and Single proprietor circumstances.

1. Excel File is Locked for Modifying By One other Consumer – Single Proprietor Case

While you open an Excel file, Microsoft Workplace creates a brief possession file and robotically deletes this file as quickly as you shut the Excel File.

Nevertheless, typically the file doesn’t shut correctly and the non permanent possession file stays within the reminiscence, resulting in “File in Use and File is Locked for enhancing” error in Excel.

The repair for this subject is to find and delete the non permanent possession file out of your pc.

1. Proper-click on the Begin button and click on on File Explorer.

2. On the File Explorer display, navigate to the situation of the non permanent possession file having identify ~$<filename> and delete this file.

For instance, if the Excel file that you simply wish to open/Edit is instance.xls, you’ll discover a brief possession file having the identify ~$instance.com.

When you delete the non permanent possession file, it is possible for you to to open/edit your Excel File, with out encountering “File is Locked for enhancing by one other consumer” message.

2. Shared Excel File is Locked for Modifying By One other Consumer

If you’re getting “File is Locked for Modifying by one other consumer” message in case of a Shared File, you possibly can ask the opposite Consumer to shut the File or use the co-authoring function in Excel.

Nevertheless, if the opposite Consumer has left the File open and is at the moment unavailable, you possibly can observe the steps beneath to remotely shut the file.

Observe: It’s good to have Admin entry to the server the place the Excel file resides, so as to have the ability to remotely shut open information on a community.

1. Observe down the File Identify and the Path to the Excel File.

2. Proper-click on the Begin button and click on on RUN.

Observe: You can even press Home windows + R keys to carry up the Run command.

3. In Run Command window, sort mmc and click on on OK to carry up Microsoft Administration Console.

4. On the subsequent display, click on on File > Add/Take away Snap-in.

5. On the Add or Take away Snap-ins display, choose Shared Folders and click on on the Add button.

6. On the subsequent display, choose One other pc and click on on the Browse button to find the opposite pc on which the Excel File resides.

As soon as you discover the Different pc, choose Open Information choice and click on on the End button (See above picture).

7. Again on the Add or Take away Snap-ins display, click on on OK to Add the Snap-in to handle Shared Information on one other pc.

8. On the subsequent display, develop the checklist of Open Information > right-click on the Locked Excel File and click on on Shut Open File choice.

As soon as you’ll be able to remotely shut the open Excel file, the opposite consumer shall be faraway from the File and it is possible for you to to open the locked Excel file and make adjustments to it.

• How one can Repair Microsoft Excel Not Responding Error in Home windows 10
• How one can Print to PDF or Save As PDF in Microsoft Excel