• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Excel: Fix “File is locked for editing/in use” Errors

Excel: Fix “File is locked for editing/in use” Errors

February 27, 2023 by Mitch Bartlett 11 Comments

When working the helpdesk, I get many calls from users who say they cannot edit a Microsoft Excel file because it is locked and in use by other user.

The message that appears will say “File in Use – {filename] is locked for editing by {username}. Open ‘Read-Only” or click “Notify to receive notification when the document is no longer in use.”

If the user is away at lunch or gone for the day, and the file needs to be edited now, it makes it quite the conundrum. Fortunately, there is a way to kick the user out of the file remotely.

Note: These steps are for System Administrators or personnel with Administrator access to the server where the Excel file resides. If you cannot perform these steps, talk to your IT folks for them to perform these steps for you.

To boot the user from the file and allow another user to access it, follow these steps:

  1. Note the path to the file, and the file name.
  2. Hold the Windows Key and press “R” to bring up the Run dialog box.
  3. Type “mmc“, then press “Enter” to bring up the “Microsoft Management Console“.
  4. Select “File” > “Add/Remove Snap-in“.
  5. In the list of “Available snap-ins“, select “Shared Folders“, then select “Add” to add it to the “Selected snap-ins” list.
  6. A box will appear that asks you to “Select the computer you want the snap-in to manage“. If you are logged in on the server where the locked Excel file resides, choose “Local computer“. If you are logged in at a different computer, select “Another computer“, then type or Browse to the server where the Excel file resides.
  7. In the view section, select “Open Files“.
  8. Select “OK“
  9. Expand the list of “Open Files“.
  10. Sort the list as desired. I personally like to sort by username. Find the file in the list, then right-click the file and choose “Close Open File“.

That’s it! You have disconnected the user who had the file open and unlocked it. The new user who wants to edit the file now will be able to exit Excel, then re-open the file to edit it.

You Might Also Like

  • Solve "The iTunes Library.itl file is locked" Error in iTunes
    Solve "The iTunes Library.itl file is locked" Error in…
  • Fix Windows 10 File History Errors 200, 201 and 203
    Fix Windows 10 File History Errors 200, 201 and 203
  • Fix: System Registry File Is Missing or Contains Errors
    Fix: System Registry File Is Missing or Contains Errors
  • Excel: How to Easily add a Password to a File
    Excel: How to Easily add a Password to a File
  • Microsoft Excel: How to Import Data from a PDF File
    Microsoft Excel: How to Import Data from a PDF File
  • Excel: This File Couldn't Open in Protected View
    Excel: This File Couldn't Open in Protected View

Filed Under: Office, Windows

Reader Interactions

Comments

  1. John says

    October 6, 2022 at 6:15 am

    Thank you Mitch. I was working from home accessing our work server via a vpn when the internet went down.
    Using your advice I was able to get this sorted.
    So grateful …..saved me a bunch of time!
    John

  2. AlexBuslovich says

    February 7, 2020 at 12:44 pm

    Great solution. Works for me. Thank you.
    Alex

  3. Alberto Catalano says

    November 10, 2019 at 4:09 pm

    Thanks so much. After an hour of searching this was the only solution that worked for me.

  4. Beth Bretton says

    September 20, 2019 at 3:24 pm

    This is my own computer and I created the file. It isn’t out there shared with anyone and it clearly says that i created the file within the properties of the file. but i can’t open it. and when i follow this process, there are no open files. So, that’s not going to work. sigh….

  5. J.J. says

    July 30, 2019 at 7:51 am

    Only problem is, it is my own file, on my machine, nobody else has access to it, no other copies are open either.

  6. Aris says

    July 28, 2019 at 8:31 pm

    only good if you have admin rights on your network which most people don’t have . Would love a user level solution.

  7. Kenneth says

    July 12, 2019 at 4:44 am

    It’s really work for me. It is the best solution for this case.

  8. Ryan says

    May 2, 2019 at 11:40 am

    Thanks! Quick and to the point.

  9. Lois says

    April 6, 2019 at 5:50 pm

    I’m the only one who has access and I’m still getting this error message.

  10. Dan says

    February 11, 2019 at 10:06 am

    Worked for us too. Literally went through every other solution possible.
    Thank you very much!

  11. Richard Taylor says

    October 10, 2018 at 3:00 am

    Yes, it did work, thankyou, after a lot of suggestions that didn’t. We are using Excel 2013

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • 3 Ways to Choose All Files in a Folder – Windows 11
  • Apple TV+: How to Erase a Show From the Up Next List
  • How to Change the Profile Picture on Disney+
  • Local Security Policy: What Is It and How to Open It in Windows 11
  • How to Create and Erase an Alarm in Windows 11
  • 10 Best NAS Storage Device for Home and Professional Use
  • PS5 NVMe Requirements You Must Fulfill to Expand PS5 Storage
  • Steam Deck Won’t Turn On: 8 Possible Fixes You Can Try

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Best CPUs for Video Editing 2022
  • Encapsulated Postscript (EPS) File
  • File Compression Utility

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy