Why your Excel file is locked on OneDrive

Find out whether the lock follows the file or an app

One person opening a shared workbook in an Excel version without coauthoring support can trigger a lock error for everyone else. Those colleagues can have suitable apps and edit access of their own. The file’s location on OneDrive has not changed, but one participant has stopped the group from editing together.

Ask everyone to finish saving and close their desktop sessions, then open the original sharing link in a browser. If both people can edit there, reopen through desktop Excel one person at a time. If the lock returns when a particular colleague opens their app, inspect that installation and its signed-in account. Browser editing has removed the immediate obstacle; any macro-driven tasks still need the desktop checks below.

What happens	What to try next	What the result tells you
Both people can edit in the browser	Introduce desktop sessions individually	Whether opening a particular app brings the lock back
The recipient can only view in the browser	Have the owner inspect that account’s access	Whether editing was actually granted
The lock names you	Close the workbook on your other devices and allow time for release	Whether an earlier session was holding the file
People can type, but their numbers diverge	Compare the original link and check saving/sync status	Whether they are editing copies or changes are not reaching the cloud

Microsoft’s lock troubleshooting page specifically lists Excel 2016, 2019, and 2021 LTSC as not supporting coauthoring. Use an up-to-date Microsoft 365 desktop app signed in with the subscription account, or use Excel for the web. For a lock left by your own session, close the file on all devices and give the server a few minutes to release it.

An editable link must lead to the same original

Modern coauthoring uses a workbook stored in OneDrive, OneDrive for Business, or SharePoint Online. Sending an attachment gives recipients a copy. If one person updates the attachment while another works in the cloud, matching filenames do not make the two files a shared editing session.

Open the original’s folder online, select the workbook, and choose Share. Set the intended recipients and editing permission before copying the link. “People with existing access” does not grant new access; it is useful for sending someone back to a file they can already use. An organization may restrict other sharing choices. A disabled option needs the owner or administrator’s attention, rather than a different URL pasted into the invitation.

For an example onboarding check, use a blank area of an order workbook. Have the sales colleague type a test label in one cell and the scheduling colleague type another in a different cell. Each should see the other’s entry. Remove the labels afterward. This checks the actual route your team will use before either person spends an hour entering orders into the wrong copy.

Browser editing preserves macros but cannot run them

Supported coauthoring formats include .xlsx, .xlsm, and .xlsb. Strict Open XML Spreadsheet is excluded. Convert an older .xls workbook using Excel’s Save As options while retaining the original; renaming an extension is not conversion. Choose a format appropriate for the contents instead of assuming every workbook can become a plain .xlsx file without losing features.

An .xlsm workbook is not automatically disqualified because it contains VBA. Excel for the web can edit a workbook containing macros and retain them, but it cannot create, run, or edit VBA macros. A successful browser editing check therefore says nothing about whether the “Create invoice” button can run there.

Consider an order workbook where colleagues enter quantities and one coordinator runs an invoicing macro. The input task and the macro task can use different clients. Changing the macro’s code is another operation again: Microsoft advises doing that when others are not actively coauthoring, because code changes can interrupt their work.

Do not enable Shared Workbook (Legacy) as a generic fix for a cloud lock. That older collaboration feature has different restrictions, including no editing in Excel for the web and limitations around tables and charts. If an inherited workbook already uses it, have its owner review that setup before changing the team’s workflow.

AutoSave also saves experiments

AutoSave saves Microsoft 365 cloud files every few seconds. Keep it enabled for normal shared work and resolve saving errors. With OneDrive desktop sync, also check that synchronization has not been paused. Being able to type into a local window does not show that another editor has received those changes.

AutoSave changes how to reuse last month’s report. If you clear its numbers and plan to save under a new name afterward, the clearing may already have reached the original. Use File → Save a Copy before changing the template. Once the new report is ready for shared input, distribute that file’s link.

In the order-workbook example, decide who owns quantity entry and who owns delivery dates. This is an editing convention, not a permission boundary. If two people enter different quantities into the same cell, the last saved change generally wins; Excel cannot decide which quantity the customer actually requested. Keep discussion in a comment and have the responsible person enter the agreed number.

Use Sheet Views for different filters, not private data

Two editors often need different slices of the same order list. Select View → Sheet View → New before sorting or filtering, then rename the Temporary View if you want to reuse it. Have the other editor create a view too. Each can inspect the rows relevant to their work without sharing the same filtering choices.

Sheet Views do not create private copies of cell values. An edit still changes the workbook, and other people can select your saved view. Someone remaining in the Default view can still be affected by others’ sorting or filtering, so having everyone use their own view is the more useful arrangement.

For example, sales might filter for one region while scheduling sorts by delivery date. Refer to an order number when discussing an entry, rather than “the fifth row on my screen.” The two views can place the same order at different positions.

Investigate a cell before rolling back a workbook

Select a suspicious cell or range, right-click, and choose Show Changes. For the whole workbook, use Review → Show Changes. The pane identifies the editor, location, time, and change, with previous values where available. The current Microsoft instructions, checked October 27, 2026, specify a 365-day lookback.

This is not a complete visual audit. Formatting, charts and objects, PivotTable operations, hiding, and filtering are not shown. Editing through older or one-time-purchase Excel versions, or replacing the file, can also clear the pane. An empty list does not establish that the workbook has never changed.

If just order A-104 has an incorrect quantity, compare the recorded edit with the order itself and correct that cell. There is no need to roll back all the delivery dates another colleague entered this morning. Version History addresses a wider recovery problem: returning the workbook to an earlier state.

Preserve unsynced work before reopening

When an upload failure leaves changes you need to keep, save a separately named copy first. Reopen the cloud original and transfer the necessary edits from the saved copy. That is the recovery sequence in Microsoft’s coauthoring guidance. Do not discard unsaved work that exists nowhere else.

In the example, your copy may contain corrected quantities while the current original contains newer delivery dates. Uploading the whole copy over the original could undo the scheduling colleague’s work. Compare the affected orders and transfer the required cells instead.

For extensive damage, preserve the current state, have everyone stop editing, and open Version History from the file’s folder. Inspect the earlier version before selecting Restore. Restoring replaces the current version with the selected one, including rolling back updates made afterward. Reopen the shared original, check the recovered formulas and orders, and reapply any valid later entries from your preserved copy before the team resumes.