What "locked for shared use" means in SharePoint
SharePoint says a file is "locked for shared use" by a named person when you try to check it out, replace it or change its properties while it is open for editing somewhere, or was not closed cleanly. Microsoft has no documentation article for this exact message. The explanation comes from Microsoft community moderators answering in Microsoft Q&A, one of whom puts it this way: "This error message usually occurs when a file is being edited by another user or when the file is open in another program."
That is a different thing from a check out. A check out is deliberate: Microsoft describes check out and check in as a way to "lock a file for exclusive editing and then to release the lock for others." Work out which one you have first, because the fixes differ.
| What you see | What it is | What clears it | Where the guidance comes from |
|---|---|---|---|
| A message that the file is "locked for shared use" by a named person, when you check out, replace or edit the properties of a file | The file is open for editing in a browser or an Office app, or was not closed cleanly | Closing the file everywhere, then waiting for the lock to release | Microsoft Q&A answers from Microsoft community moderators |
| A small icon to the right of the file name, and the Check out command is not available | A check out: one person has the file locked for exclusive editing | That person checking the file in, or someone with the Override Check-Out permission | Microsoft Support articles on check out and check in |
| Excel reports that the file is locked for editing | Someone has the workbook open in a version, format or feature that does not support co-authoring | The fixes in Microsoft's Excel article | Microsoft Support article "Excel file is locked for editing" |
Fix "locked for shared use"
The people who report this message in Microsoft Q&A met it while checking out a file, replacing a file, and editing a file's properties or metadata in a SharePoint Online library. The steps below are the ones Microsoft's moderators and Microsoft's Excel article give, starting with the quickest.
- Ask the named person to close the file. The moderators' answers say the message appears when the file is open in the browser or in an Office app, and that users "need to close them first from Office clients or the browsers."
- Close it yourself, everywhere. The name in the message can be your own. Microsoft's Excel article on locked files says that sometimes the other user is actually you, because the file is open on a different device or the previous instance of the file did not close properly. Its first step is to close the file on all your devices.
- Wait for the lock to release. A Microsoft community moderator states: "the lock stays for 10 minutes, however, it might take up to 30 minutes to 1 hour to release the lock from server automatically." Microsoft's Excel article says to wait "a few minutes for the server to release the lock on the file."
- Clear the browser cache and restart the browser. The same moderator says the problem can follow an unexpected close, where a cached copy still shows the file as in use, and gives the fix as: "clear your browser cache, restart your browser, and clear your cache in credential manager."
- Check whether the file is checked out. If it is, the sections below apply.
- Raise it with Microsoft Support. For a SharePoint Online library where files stayed locked after all of the above, the moderator's answer was that it needs investigating from the back end, and that a Microsoft 365 admin should create a support ticket. Microsoft's own page of check out questions ends the same way: file a service request.
See whether a file is checked out, and who has it
Microsoft gives two ways to find out:
- Point at the file. When a file is checked out, a small icon appears to the right of the file name. Pointing at the file name shows its details, including the name of the person who has it checked out.
- Add the Checked Out By column. Microsoft's check out questions page suggests adding the Checked Out By column to the library's default view, so the name shows for every file. What are SharePoint Online views? covers adding a column to a view.
Microsoft also says there is no way to set a reminder for a checked-out file or to get the check-out date from SharePoint, so the icon and the column are the tools you have.
Check out, check in and discard
These steps are from Microsoft's Support article "Check out, check in, or discard changes to files in a SharePoint library".
Check out a file
- Go to the document library where the file is saved.
- Select the file or files you want to check out.
- Above the documents list, select the More menu (...), then select Check out.
In the classic experience, Check out is on the Files tab of the ribbon. Once the file is checked out you can edit it online or offline and save it as many times as you need. Your changes are not available to colleagues until you check the file back in.
Check in a file
- Select the file or files you want to check in.
- Above the documents list, select the More menu (...), then select Check in.
- In the Comment area, add a comment that describes your changes. Microsoft calls this optional but recommended, and says the comment becomes part of the version history if versions are tracked.
- Select OK. The check-out icon disappears.
Three points from Microsoft that catch people out:
- Checking in does not save for you. Microsoft's answer to "Are my files saved automatically when I check them in?" is no. Save your changes first.
- A downloaded copy has to be uploaded. If you downloaded the file to work on it locally, upload it before you check it in.
- Excel has two routes. In desktop Excel for Windows, select File > Info > Check in. In Excel for the web you can only check in from the library: close the browser tab for the file, then follow the library steps.
Discard a check out
- Select the file or files.
- Above the documents list, select the More menu (...), then select Discard check out.
- Select Yes.
Discarding means your unsaved changes are not kept, and no new version is created if the library tracks versions.
Someone else has the file checked out
Microsoft's answer to "Someone went on vacation and left a file checked out. Now what?" starts: "You don't have to wait for them to come back."
To check in a file that another person has checked out, follow the check-in steps above. Microsoft says you get a warning dialog box that the file is checked out to another person, and that you select OK to override.
You need permission to do it. Microsoft's permission reference names it Override Check-Out and describes it as: "Discard or check in a document that is checked out to another user." Its table shows which default permission levels include it:
| Permission level | Includes Override Check-Out |
|---|---|
| Full Control | Yes |
| Design | Yes |
| Approve | Yes |
| Manage Hierarchy | Yes |
| Edit | No |
| Contribute | No |
| Read | No |
Microsoft adds two cautions. Its tip is "Ask before overriding someone else's check out", and it warns that the colleague's local copy may need to be reconciled with the library version, manually or with comparison tools. SharePoint permission levels explains each level and which group gets it.
Why other people cannot see a file you uploaded
In a library that requires check out, Microsoft says a file you create or add "is initially checked out to you", and that you must check it in before others can see it and work with it. If the library has required properties, fill them in and then check the file in.
The Require Check Out setting
A library can be set so that every file must be checked out before it is edited. Microsoft's steps:
- Go to the library.
- Select Settings, then Library settings.
- On the Settings page, select More library settings, then Versioning settings. In the classic experience, Versioning settings is under General Settings.
- In the Require Check Out section, under "Require documents to be checked out before they can be edited?", select Yes to require check out or No to remove the requirement.
- Select OK.
Microsoft states: "Only users who have Full Control or Design permissions can set up libraries to require check out of files." The requirement is off by default.
What changes when check out is required
| You do this | What Microsoft says happens |
|---|---|
| Create or add a file | The file is initially checked out to you, and others cannot see it until you check it in |
| Open a file for editing | The file is checked out to you automatically when you select Edit. No one else can change the file or see your changes while you have it checked out |
| Change the file's properties | You must check the file out first, and the changes do not take effect until you check it back in |
| Try to open a file that is checked out to someone else | "The Check Out and Check In options are unavailable." A message says the file is checked out by someone else, and hovering over the file icon shows who |
| Keep a file checked out for a long time | No one else can see your changes or edit the file. "In some circumstances, an administrator may have to force a check in of the file." |
Should it be on?
Microsoft's guidance depends on how the team works:
| How the team works | Microsoft's guidance |
|---|---|
| Informal | Leave the check out requirement off, and check out individual files as needed |
| Co-authoring | Leave it off and avoid checking out, because checking out is "incompatible with co-authoring" |
| Formal, with sequential review and approval | "Enable required check out" |
On co-authoring, Microsoft is direct: "Users cannot work simultaneously on documents when required check out is turned on." For people who want to work in an Office document together, its advice is not to check the document out and to just open it and edit it. Microsoft also recommends turning on at least major versioning in a library used for co-authoring, so an earlier version can be restored. Best ways to manage version history in SharePoint covers the versioning settings, and SharePoint version history storage covers what versions do to your storage figure.
When Excel says the file is locked for editing
Excel has its own article, "Excel file is locked for editing". It lists these causes and fixes:
| Cause | Microsoft's fix |
|---|---|
| You have the file open on another device, or the previous instance did not close properly | Close the file on all your devices. If the error persists, wait a few minutes for the server to release the lock |
| Another person has the file open | Wait until they finish and close it, open it read-only, or ask them to close the file or check it in |
| Someone is using a version that does not support co-authoring | Make sure everyone uses a version that does. Microsoft notes: "Excel 2016, 2019, and 2021 LTSC do not support co-authoring." |
| The file format | Save the workbook as .xlsx, .xlsm or .xlsb with File > Save As. Microsoft notes that co-authoring does not support the Strict Open XML Spreadsheet format |
| A feature that co-authoring does not support | Password encryption or restricted access, Refresh data when opening file on tables or PivotTables, an add-in, the Shared Workbook feature, or a snapshot opened from SharePoint |
| The workbook is in a library on a SharePoint On-Premises site | Microsoft suggests using Excel Online for those libraries |
One detail explains why a single person can lock a workbook for a whole team: Microsoft says that if one person uses a version that does not support co-authoring, everyone else gets the locked error, even if they use a version that does.
For Word and PowerPoint, Microsoft's article "Document collaboration and co-authoring" sets the conditions: co-authoring is supported only on modern file formats, including .docx, .pptx and .xlsx, all co-authors must have permission to access and edit the documents, and it is not available for documents protected with Information Rights Management.
SharePoint Server
Microsoft's "Overview of co-authoring in SharePoint Server" applies to SharePoint Server only. It states: "When a user checks out a document for editing, the document is locked for editing by that user", and that check out prevents co-authoring. It warns that forgetting to close a document or check it in "may lock out other users indefinitely". It also says the Excel client application does not support co-authoring workbooks in SharePoint Server, which is done with the Excel Web App.
Which products Microsoft's articles cover
| Microsoft article | Applies to |
|---|---|
| Check out, check in, or discard changes to files in a SharePoint library | SharePoint in Microsoft 365 and SharePoint Server 2016, 2019 and Subscription Edition |
| Top questions about check out, check in, and versions | SharePoint in Microsoft 365, with some steps given for SharePoint 2016 |
| Set up a library to require check out of files | SharePoint in Microsoft 365 and SharePoint Server 2013, 2016, 2019 and Subscription Edition |
| Understanding permission levels in SharePoint | SharePoint in Microsoft 365 |
| Document collaboration and co-authoring | SharePoint in Microsoft 365 and SharePoint Server 2016, 2019 and Subscription Edition |
| Excel file is locked for editing | Excel for Microsoft 365 and Excel 2016, 2019, 2021 and 2024 |
| Overview of co-authoring in SharePoint Server | SharePoint Server 2013, 2016, 2019 and Subscription Edition |
When it is the site that is locked
If every file in a site refuses changes, the lock is on the site and not the file. SharePoint site lock states explains read-only and no-access sites and how to unlock them. If the message is about permission, SharePoint 'Access Denied' and 'You Need Permission' covers the access errors.
Frequently asked questions
What does "locked for shared use" mean in SharePoint?
Microsoft has no documentation article for the message. Microsoft community moderators in Microsoft Q&A say it usually occurs when the file is being edited by another user or is open in another program, including a file that was not closed cleanly.
How long does a SharePoint file lock last?
A Microsoft community moderator states that the lock stays for 10 minutes but can take up to 30 minutes to 1 hour to release from the server automatically. Microsoft's Excel article says to wait a few minutes for the server to release the lock.
Why does SharePoint say the file is locked by me?
Microsoft's Excel article says the other user is sometimes you, because the file is open on a different device or the previous instance did not close properly. Close the file on all your devices and wait for the lock to release.
How do I see who has a file checked out in SharePoint?
Point at the file name to see its details, including who has it checked out, or add the Checked Out By column to the library view.
How do I check in a file that someone else checked out?
Select the file, select the More menu, then Check in. A warning says the file is checked out to another person, and selecting OK overrides it. You need the Override Check-Out permission.
Which permission lets me override a check out?
Override Check-Out, which Microsoft describes as "Discard or check in a document that is checked out to another user." Full Control, Design, Approve and Manage Hierarchy include it by default. Edit, Contribute and Read do not.
What happens when I discard a check out?
Your unsaved changes are not kept, and no new version is created if the library tracks versions.
Why can't other people see the file I uploaded to SharePoint?
If the library requires check out, the file is initially checked out to you. Fill in any required properties and check it in, and others can then see it.
Does check out stop co-authoring?
Yes. Microsoft says users cannot work simultaneously on documents when required check out is turned on, and describes checking out as incompatible with co-authoring. To co-author, open the document and edit it without checking it out.
Where is the Require Check Out setting?
In the library, select Settings, then Library settings, then More library settings, then Versioning settings. The setting is in the Require Check Out section. Microsoft says only users with Full Control or Design permissions can change it.
Related reading
- SharePoint document libraries: structure and management - how libraries, versioning and metadata fit together.
- SharePoint permission levels - what each level allows and which group gets it.
- Best ways to manage version history in SharePoint - the versioning settings next to Require Check Out.
- What are SharePoint Online views? - add the Checked Out By column to a view.
- SharePoint site read-only or no access: lock states and how to unlock - when the whole site is locked.
- SharePoint 'Access Denied' and 'You Need Permission': fixes - the access errors and their fixes.
- SharePoint 'Sorry, Something Went Wrong': causes and fixes - the generic error and what to give Microsoft Support.
Mark Smith co-founded SmiKar Software in 2015 and has spent the past decade helping organisations solve Microsoft 365 data management challenges. He works with the SmiKar team to build solutions for SharePoint archiving, storage optimisation, governance and compliance, supporting customers from growing businesses through to Fortune 500 enterprises.
More about SmiKar


