# Excel file locked by another user: the fix and the long-term fix

> For the full documentation index, see https://250highstreet.com/llms.txt

> Excel says a file is locked for editing by another user. Here are the steps to get back in, why it happens, and how to stop it for good.

Short answer: close the file on every device you use, then wait a few minutes for the server to release the lock, because the "other user" can be you. If a coworker has it open, wait until they close it, open the file read-only, or ask them to close it, check it in, or give you edit access. If this keeps happening, the real problem is that several people share one spreadsheet. One way to stop it for good is to move the shared records to a SharePoint list.

## Fix it now: the quick steps

These steps follow Microsoft's own support page on this error. Exact names may differ on your screen.

1.  Close the file on every device you use. Check your laptop, phone and tablet. Sometimes the "other user" is you.
2.  If the message stays, wait a few minutes. Microsoft says the server may need that time to release the lock.
3.  If someone else has the file open, you have choices. You can wait until they close it. You can open the file read-only. Or you can ask them to close it, check it in, or give you edit access.
4.  If the file opens as Viewing only, look for the Request more access option. It lets you ask the owner for edit or review permission.
5.  Our advice, not a Microsoft rule: if you need to work right now, save a copy of the file and make your changes in the copy. Then you must add those changes to the main file later. This is the weak spot: it creates a second version. Use it only when you must.

## Why Excel says "locked for editing"

Microsoft lists these causes:

- Another person has the file open.
- You have the file open on another device.
- An earlier session did not close the right way, so the server still holds the lock.

There is a further cause. Microsoft says that if even one person opens the file in a version of Excel that does not support co-authoring, everyone else can get the "locked" message. So one old copy of Excel can lock out the whole team.

## Locked, but nobody has it open

Microsoft lists an earlier session that did not close the right way as a cause: the server still holds the lock. To clear it, close the file on every device you use, then wait a few minutes for the server to release the lock. If the message stays after that, work through the checks below. Microsoft's page does not cover closing another user's session on a file server. If you manage that server, or you cannot find who holds the file, ask your IT administrator.

## Network share or SharePoint: which one are you on

Where the file is saved changes what is possible. Microsoft says co-authoring needs the file saved to OneDrive, OneDrive for Business or a SharePoint Online library. It says server paths, local folders, other cloud storage and SharePoint On-Premises libraries do not support co-authoring. So a file on a network share or shared folder is open for one person at a time. Moving the file to OneDrive or a SharePoint Online library is the step Microsoft points to for co-authoring.

## Check these things if it keeps happening

Work through this list in order. Stop when the error goes away.

1.  Where is the file saved? Co-authoring works for files in OneDrive, OneDrive for Business or a SharePoint library in Microsoft 365. Microsoft says it does not work for files on a server path, in a local folder, on other cloud storage, or in a SharePoint On-Premises library.
2.  Which Excel version does everyone use? Microsoft says co-authoring works in Excel for Microsoft 365 (Windows and Mac), Excel for the web, and the Excel apps for Android and iOS. It says Excel 2016, 2019 and 2021 LTSC do not support it. People on work or school accounts may need their administrator to provide the latest version.
3.  What is the file format? The file must be .xlsx, .xlsm or .xlsb. Microsoft says the Strict Open XML Spreadsheet format is not supported.
4.  Is the OneDrive sync app up to date and not paused? Microsoft lists this as a check.
5.  Is the old Shared Workbook feature on? Microsoft says to turn it off first.
6.  Does the file use a password, restricted access, or data that refreshes when the file opens? Microsoft lists these as features that can block co-authoring on Windows, along with some add-ins. The page gives the exact menu paths for Windows and Mac.

If you do not know how to check these, or whether your plan includes the latest Excel, ask your Microsoft 365 administrator.

## What co-authoring can and cannot do

Co-authoring lets several people edit one workbook at the same time. Microsoft documents these requirements:

- A Microsoft 365 subscription version of Excel, signed in, or Excel for the web.
- The file saved in OneDrive, OneDrive for Business or a SharePoint Online library.
- A supported file format.

Microsoft also says some Excel features are not fully supported in co-authoring yet. When that happens you may see a "Refresh recommended" or "Upload failed" message. Microsoft's suggested fix is to refresh, discard your changes, or save a copy and redo your edits in the cloud version.

Co-authoring helps with the locking error. It does not solve everything. Two people can still change the same cell. People can still sort a table and confuse each other. And a spreadsheet has no owner column, no status rules and no way to alert someone when a row is late.

## Why the lock is a symptom

The lock message is Excel telling you that a file built for one person is being used by many. Look at how your team uses the file:

- Several people add or change rows every day.
- Rows have an owner, a status or a due date.
- People ask each other "are you still in the file?"
- Someone keeps a private copy "just in case."

If you see these signs, you are using a spreadsheet as a shared database. You can keep patching the lock errors, or you can change the tool.

## The long-term fix: move the tracking to a SharePoint list

A SharePoint list is built for many people to add and edit records at the same time. Each record is a row that people edit one at a time, so there is no whole-file lock to fight over. For a longer look at the two tools side by side, see "[SharePoint list vs Excel for team tracking: which one fits?](/guides/sharepoint-list-vs-excel/)". For the full move step by step, see "[Replace a spreadsheet tracker with a SharePoint list](/guides/replace-spreadsheet-with-sharepoint-list/)".

Here is one way to start. Pick one spreadsheet that causes lock errors, not all of them.

## Step 1. Prepare the spreadsheet

1.  Make a copy of the file and work in the copy. Keep the original until the list is proven.
2.  Delete blank rows and stray notes above the headings.
3.  Make sure each column holds one kind of thing: all dates, all names, all numbers.
4.  Put the data in an Excel table. Microsoft says the import needs a table, and you can use Format as Table on the Home tab.
5.  Check the row count. Microsoft says a table can have up to 5,000 rows for this import.

## Step 2. Import it as a list

Microsoft documents this path. Exact names may differ.

1.  In Microsoft 365, open the app launcher and choose Lists, then New list. In SharePoint, choose Create, then List.
2.  Choose From Excel.
3.  Upload your file or pick one from OneDrive. Microsoft says a file uploaded from your device is saved in the site's Site Assets library.
4.  Choose the table, choose the details to include, and choose Next.
5.  Add a name and choose where to save the list.
6.  Choose Create.

If the Upload file button is greyed out, your account may not have permission to create lists from a spreadsheet. Ask your administrator. If your file type is not supported, Microsoft says to export it to CSV and import that file.

## Step 3. Fix the columns

Microsoft says column types are mostly based on the data, and that you should review them after import. A money column may need to be changed from a plain number to currency in List Settings.

One check that saves trouble:

1.  Microsoft says importing a spreadsheet is one way to create a list without the default Title column. If your list has a Title column anyway, rename it to something useful, like "Item" or "Request".

## Step 4. Add owners and status

This is where the list becomes better than the spreadsheet. Add a Person column for the owner, a Choice column for status, and a date column for the due date. Then create a view for each person or each status. Views make it easy to find your rows.

## Step 5. Switch over

1.  Tell the team the date the spreadsheet stops being the record.
2.  Set the old file to read-only, or move it to an archive folder with the word "OLD" in the name.
3.  Send people the link to the list, not the file.
4.  After two weeks, review what is missing and fix the columns.

Keep Excel for what it is good at. If someone needs to build a chart or study the numbers, they can export the list to Excel. That one-way copy does not need to be locked.

## What to avoid

- Our advice, not a Microsoft rule: do not force-close other people's sessions without asking them first. They can lose their changes.
- Do not make "my copy" files to get around a lock. Each copy becomes a new version to merge.
- Do not import the whole messy workbook. Clean one table first.
- Do not move everything at once. Start with the one file that locks the most.
- Do not skip the cutover date. If the old file stays editable, people will keep using it.
- If the old spreadsheet is kept for history, do not email it around. See "[Spreadsheet versions out of sync: why it happens and how to fix it](/guides/spreadsheet-versions-out-of-sync/)".

## Honest limits

A list is not a spreadsheet. It has no free-form formulas across rows and no pivot tables. Very large data sets need care. If your work is mostly calculation, keep it in Excel and store the file in a SharePoint library or OneDrive so co-authoring works. A list is best for records that many people add and update: requests, tasks, orders, issues.

## When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: \$5,000 for one, built in 2 weeks. See "[What a SharePoint tracker costs to build](/guides/what-a-sharepoint-tracker-costs/)". Bring one example of the problem to a free call.

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: [Tools I built](/portfolio/)

## FAQ

### Why is my Excel file locked when nobody has it open?

Microsoft lists an earlier session that did not close properly, so the server still holds the lock. Close the file on all your devices and wait a few minutes.

### Why does a file on a network share or shared folder lock for everyone else?

Microsoft says co-authoring needs OneDrive, OneDrive for Business or a SharePoint Online library, and that server paths do not support it. So only one person can edit it at a time. Move it to OneDrive or a SharePoint Online library.

### How do I unlock an Excel file locked by another user?

Close it on all your devices and wait a few minutes. If someone else has it open, wait, open it read-only, or ask them to close it, check it in, or give you edit access.

### Can two people edit the same Excel file at once?

Yes, if the file is in OneDrive, OneDrive for Business or a SharePoint Online library, and everyone uses a version of Excel that supports co-authoring. One person on an older version can cause the locked message for the others.

### How big a spreadsheet can I turn into a list?

Microsoft says the Excel import accepts a table of up to 5,000 rows. For larger data, check the limits for your plan first, and ask your administrator.

## Sources

- [Microsoft Support, Excel file is locked for editing](https://support.microsoft.com/en-us/office/excel-file-is-locked-for-editing-6fa93887-2c2c-45f0-abcc-31b04aed68b3)
- [Microsoft Support, Collaborate on Excel workbooks at the same time with co-authoring](https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104)
- [Microsoft Support, Create a list based on a spreadsheet](https://support.microsoft.com/en-us/sharepoint/lists/data-and-lists/create-a-list-based-on-a-spreadsheet)

## Related guides

- [Fix "file is locked for shared use" in Power Automate](/guides/power-automate-file-is-locked-for-shared-use/)
- [Copy a SharePoint file to another site with Power Automate](/guides/power-automate-copy-file-to-another-sharepoint-site/)
- [SharePoint people picker cannot find a user or guest](/guides/sharepoint-people-picker-user-not-found/)

Source: https://250highstreet.com/guides/excel-file-locked-by-another-user/