• 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
Release a File Lock in Windows

Release a File Lock in Windows

May 2, 2018 by Mitch Bartlett 11 Comments

If you work in IT, you’re probably familiar with Microsoft Windows users constantly locking files where others are not able to edit them. The problem of locked files seems to be most common with Microsoft Excel users.

It’s very common for users to leave an Excel spreadsheet open, causing an “Excel is locked for editing by another user” error to display for other users attempting to make changes to the spreadsheet.

If you have admin rights, you can force a disconnect and release the file lock using these steps.

Note: If you do not have permissions to release file locks, you may want to ask a person who does to grant you access or ask them to perform these steps.

  1. Hold the Windows Key and press “R” to bring up the Windows Run dialog screen.
  2. Type “mmc“, then press “Enter“.
  3. Go to “File” > “Add/Remove Snap-in…“.
  4. Scroll down and select “Shared Folders“, then choose “Add“.
  5. Select “Local computer” if you are logged into the computer or server where the file resides. Otherwise, select “Another computer“, then type the Computer Name of the other computer. You may also select “Browse…” to find the computer name.
  6. Select “Finish“.
  7. Select “OK“.
  8. Expand “Shared Folders“, then select “Open Files“.
  9. Find the file that is locked, then right-click it and choose “Close Open File“.

Now if you have the other user close the application, then re-open the file, they should be able to edit it without a locking issue.

This post applies to Windows 10, 7, 8, Server 2008, and Server 2012.

You Might Also Like

  • Windows 10 S Mode Release Date, News, and Features
    Windows 10 S Mode Release Date, News, and Features
  • How to Automatically Lock Your Windows PC Using Dynamic Lock
    How to Automatically Lock Your Windows PC Using Dynamic Lock
  • OnePlus 8 Specs and Release Date
    OnePlus 8 Specs and Release Date
  • HTC 5G Phone Rumors and Release Date
    HTC 5G Phone Rumors and Release Date
  • How to Lock Windows 10 and Keep it Secure
    How to Lock Windows 10 and Keep it Secure
  • 4 Ways to Lock the Screen in Windows 10
    4 Ways to Lock the Screen in Windows 10

Filed Under: Windows Tagged With: Windows 10

Reader Interactions

Comments

  1. Brendan says

    November 8, 2021 at 3:24 am

    Thank you. I’ve used this page a few times now. Very useful.

  2. Andy P says

    December 3, 2020 at 4:08 pm

    Thank you for the article. This saved me from restarting the server.

  3. Russell Bride says

    May 7, 2020 at 7:20 am

    I found out that System was holding on to a file that was shared, even though it shouldn’t normally. And with this tip I could fix the problem. The sysinternals tool handle couldn’t for example get rid of the lock.

  4. Kenneth Bopuchard says

    April 28, 2020 at 9:02 pm

    I need to remove all the locks system wide, so that Linux has access to them to delete files and folders.
    I actually onlly need it on The second partition of my Windows 10 drive. It is aspparrently not possible.

    Someone said to deiable hibernation in Windows 10 but I cannot seem to find it.

  5. Marcos says

    March 4, 2020 at 4:27 pm

    Many thanks! it was very helpful.

  6. nathan says

    December 21, 2019 at 5:41 pm

    i got to the point where it said find the locked file but there were none so i thought that that wasn’t the issue and closed mmc.
    then just for the heck of it i tried opening the file again and guess what – it came up with no lock issues.
    Thanks so much for this helpful post!

  7. Stewie says

    December 11, 2019 at 7:44 am

    Thanks I really appreciate it. Like others I’d never discovered this in decades of scientific and IT work. Maybe I didn’t need it, but today I did! file locked by another user across a network.

  8. Ivo says

    August 12, 2019 at 2:22 am

    Thank you, very useful! Windows 10 told me that the file is locked by user X (but his computer was shut down) and through MMC i found out it was wrong and it was opened by user Y.

  9. Gabe says

    May 14, 2019 at 3:48 pm

    Firstly, thanks for posting this. I’ve been in IT for 20 years and had no idea how to do this.

    Secondly, Mike on Nov 17, 2018 said “caused me to delete the file”. What he meant was the entry in the “Open File” list is removed, thus removing the lock. The original file is NOT deleted, for those who might be concerned.

  10. Mike says

    November 17, 2018 at 11:05 am

    Thank you, these instructions caused me to delete the file.

  11. jimmy666 says

    June 18, 2018 at 7:16 pm

    The file lock in Windows is an insanely annoying but when it is used, the security of your system and your data is really all dependable.

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

  • How to Make a Drop-Down List in Excel: 2 Best Methods in 2023
  • Can You Mix RAM Brands: A Guide for RAM Mix and Match
  • Google Photos: How to Recover Erased Pictures
  • New Galaxy S23: Full Specs, Features, and More
  • How to Block Calls on Android
  • Mimecast for Outlook: Everything You Need to Know
  • What Is PoE?
  • Excel Calendar Template 2023: The 9 Best Sources You Must Know

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

  • Encapsulated Postscript (EPS) File
  • File Compression Utility
  • Windows 95/98
  • Microsoft Windows NT
  • Microsoft Windows
  • Microsoft Windows 95
  • Windows Media Player (WMP)
  • Top 8 Itunes Alternatives for Windows

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