
You shared a workbook, your colleague opened it, and instead of editing together you see a locked message, a read-only banner, or changes that never appear. When excel workbook shared editing not working is the problem, it means the live co-authoring setup is incomplete: the file, the app version, the permissions, or a legacy setting is blocking real-time editing. The workbook itself is usually fine, and the block is almost always one setting away from fixed.
This guide works through 15 fixes in order, from where the file lives to a fresh shared copy. The fixes cover storage, sign-in, versions, permissions, formats, and the old sharing feature that quietly blocks the new one. Work through them one at a time, and test with a second person editing alongside you after each fix.
Table of Contents
- Why This Error Happens
- Quick Checks
- Diagnosing the Problem
- Fix 1: Move the Workbook to OneDrive or SharePoint
- Fix 2: Turn On AutoSave and Sign In to Microsoft 365
- Fix 3: Make Sure Everyone Uses a Co-Authoring Version of Excel
- Fix 4: Check Sharing Permissions and the Share Link
- Fix 5: Save the File in a Modern Excel Format
- Fix 6: Turn Off the Old Shared Workbook Feature
- Fix 7: Remove File Password Protection and Restricted Access
- Fix 8: Turn Off Refresh on Open for Tables and PivotTables
- Fix 9: Close Locked Copies and Check Who Has the File Open
- Fix 10: Check OneDrive Sync Status and Storage Space
- Fix 11: Check the SharePoint Library Checkout Setting
- Fix 12: Try Excel for the Web to Isolate the Desktop App
- Fix 13: Update Excel and Microsoft 365 Apps
- Fix 14: Repair the Office Installation
- Fix 15: Save a Fresh Copy and Share It Again
- What to Avoid
- Frequently Asked Questions
- Conclusion
- Helpful Official Resources
Why This Error Happens
Live shared editing in Excel is called co-authoring. Several people open the same workbook, and each person changes appear to the others within seconds. Co-authoring only works when the whole chain is in place: the file must live in cloud storage, everyone must use a version of Excel that supports co-authoring, AutoSave must be on, and no blocking feature may be active. If any link in the chain is missing, Excel falls back to single-person editing and shows a locked or read-only message. These are the reasons that happens most often.
1. The File Lives on a Local Drive or Network Share
Co-authoring needs OneDrive, OneDrive for Business, or a SharePoint Online library. A file on your desktop, a USB drive, or a traditional network folder cannot be co-authored, because there is no cloud service to merge the changes. Excel then locks the file for the first person who opens it, and everyone else gets read-only access. Moving the file to the cloud, as Fix 1 does, is the foundation every other fix builds on.
2. AutoSave Is Off or Nobody Is Signed In
AutoSave is the switch that sends your changes to the cloud as you type, and it only works when you are signed in to Microsoft 365. If AutoSave is off, or if anyone is working unsigned in, changes stay local and never reach the other editors. The workbook looks shared but behaves like a private copy. Fix 2 turns AutoSave on and confirms the sign-in for every editor.
3. Someone Is Using an Excel Version Without Co-Authoring
Co-authoring needs Excel for Microsoft 365, Excel for the web, or the Excel mobile apps. Older perpetual versions, such as Excel 2016, 2019, and 2021, do not support it. A single editor on an old version locks the file for everyone, because Excel must protect the file from conflicting edits it cannot merge. Fix 3 checks every editor version, and it is the fix people miss most, because one person out of date blocks the whole team. When excel workbook shared editing not working affects a whole team at once, one outdated copy of Excel is often the cause.
4. Permissions Allow Viewing But Not Editing
A share link set to Can view lets people open the workbook but never edit it, and the workbook opens read-only with no obvious explanation. A link shared with the wrong people, or a file shared from a personal account to a work account without access, produces the same result. Fix 4 checks the link type, the permission level, and the exact people the file is shared with.
5. A Legacy Feature or Blocking Setting Is Active
The old Shared Workbook feature, file password encryption, restricted access, and tables set to refresh on open all block co-authoring. Each one was designed for a different era of sharing, and each one tells Excel to lock the file rather than merge changes. These settings hide in different corners of Excel, which is why Fixes 6, 7, and 8 hunt them down one by one.
6. Sync Is Stalled, Storage Is Full, or the Library Requires Checkout
If OneDrive sync is paused or broken, changes never leave the computer, so other editors never see them. If OneDrive storage is full, new changes have nowhere to go. On SharePoint, a library setting that requires checkout forces single-person editing by design. Fixes 10 and 11 check the sync engine and the library setting, because the Excel side can be perfect while the storage side silently blocks sharing.
Quick Checks
Two minutes before the deep fixes.
- Check where the file lives — look at the title bar for OneDrive or SharePoint in the path.
- Check whether AutoSave shows as On in the top-left corner of Excel.
- Check whether every editor is signed in to Microsoft 365 in Excel.
- Check whether the file opens read-only, locked, or editable-but-unsynced — each points at a different cause.
- Check whether one person can edit while others cannot, or whether nobody can edit together.
- Ask whether excel workbook shared editing not working began after a move, a rename, or a permission change — the last change is the prime suspect.
Diagnosing the Problem
| Symptom | Cause | Go to Fix |
|---|---|---|
| File locked message for the second editor | File not in cloud storage | Fix 1 |
| AutoSave greyed out or off | Not signed in, or local file | Fix 2 |
| One editor locks the file for everyone | Outdated Excel version | Fix 3 |
| Workbook opens read-only for some people | View-only share link | Fix 4 |
| Old format warning or sharing greyed out | Legacy file format | Fix 5 |
| Shared Workbook message on open | Legacy sharing feature active | Fix 6 |
| Changes never appear for other editors | Sync stalled or storage full | Fix 10 |
| Checkout prompt before editing | Library requires checkout | Fix 11 |
Fix 1: Move the Workbook to OneDrive or SharePoint
Live editing needs a cloud home for the file. OneDrive, OneDrive for Business, and SharePoint Online all support co-authoring, and the file must actually live there — a shortcut or a copy on the desktop does not count. Moving the file once, through Excel itself, sets the cloud path correctly and enables the sharing features.

- Open the workbook in Excel and click File, then Save As.
- Choose OneDrive or a SharePoint site as the save location.
- Pick the folder where the shared file should live.
- Keep the same file name, or choose a clear new name, and click Save.
- Check the title bar — it should now show the OneDrive or SharePoint path.
- Click Share in the top-right corner and confirm the sharing panel opens.
- Ask a colleague to open the file from the shared link and type one test value.
- Do not drag the file into the OneDrive folder in File Explorer and assume the job is done — saving through Excel sets the cloud identity correctly.
- If your team uses SharePoint, save into the team site library, not your personal OneDrive, so access survives staff changes.
- After the move, delete or archive the old local copy, so nobody keeps editing the wrong file by mistake.
- When the title bar shows a local path such as
C:\Users, the file is not in the cloud, and live editing cannot work.
Fix 2: Turn On AutoSave and Sign In to Microsoft 365
AutoSave sends every change to the cloud within seconds, and it is the engine of live editing. It only runs when the file is in cloud storage and you are signed in. If AutoSave is off, changes pile up locally and other editors never see them, which looks exactly like broken sharing.
- Open the workbook from its OneDrive or SharePoint location.
- Look at the AutoSave toggle in the top-left corner of the Excel window.
- If AutoSave is off, click the toggle to turn it on.
- If Excel asks you to save the file to the cloud first, accept and choose the cloud folder.
- Click your profile icon in the top-right corner and confirm you are signed in.
- If you are not signed in, click Sign in and use your Microsoft 365 account.
- Type a test value in a spare cell and ask a colleague whether it appears on their screen.
- Every editor must be signed in — one unsigned-in editor breaks the live view for the whole group.
- AutoSave being greyed out usually means the file is not in the cloud yet, so revisit Fix 1.
- On a shared computer, check that Excel is signed in as the right person, not the previous user.
- When excel workbook shared editing not working shows as changes that never appear, AutoSave is the first switch to check.
Fix 3: Make Sure Everyone Uses a Co-Authoring Version of Excel
One editor on an old version locks the file for everyone, because Excel cannot merge changes from a version that does not understand co-authoring. The supported versions are Excel for Microsoft 365 on Windows and Mac, Excel for the web, and the Excel mobile apps. Older perpetual versions do not support it at all.
- Ask every editor to open Excel and click File, then Account.
- Check the product name — it should say Microsoft 365 or Microsoft 365 Apps.
- If anyone shows Excel 2016, 2019, or 2021, that person is the blocker.
- Ask the blocker to open the file in Excel for the web instead, in a browser.
- Confirm that the web version shows the file as editable, not read-only.
- Have the blocker type a test value in the web version while others watch.
- If live editing works with everyone on supported versions, the version mix was the cause.
- The web version is free with a Microsoft account and supports co-authoring fully, so it is the quickest workaround for an outdated install.
- A person who opens the file from an email attachment gets a local copy, which never co-authors — always open from the shared link.
- Check the version on every device, including a home laptop that may run an older install.
- Keep a note of the team versions, so the next sharing fault can be diagnosed in one question.
Fix 4: Check Sharing Permissions and the Share Link
A share link set to view-only opens the workbook read-only, and the reader sees no error — just a workbook that will not accept edits. A link shared with specific people blocks anyone not named. Checking the link type, the permission level, and the named people resolves most permission faults in minutes.
- Open the workbook and click Share in the top-right corner.
- Click the permission text under the link, such as Anyone with the link can view.
- Change the permission to Can edit for the people who need to edit.
- Check whether the link is set to Anyone, People in your organisation, or Specific people.
- If it is set to specific people, confirm every editor is named on the list.
- Copy the link and send it fresh to one editor who could not edit.
- Ask that editor to open the fresh link and type one test value.
- A view-only link is the most common permission fault, and it hides in plain sight because the workbook opens without any error.
- If the workbook opens in a protected banner instead, our guide to Excel file opens in Protected View covers that separate block.
- Changing a link from view to edit applies immediately, so editors do not need a new link unless the audience also changed.
- For sensitive workbooks, prefer Specific people with edit rights over Anyone, so the sharing stays controlled.
Fix 5: Save the File in a Modern Excel Format
Co-authoring needs a modern workbook format: .xlsx, .xlsm, or .xlsb. The old .xls format and the Strict Open XML format do not support it, and Excel quietly disables live editing for those files. Saving a copy in the modern format enables co-authoring without changing the content.
- Open the workbook and click File, then Save As.
- Choose the same OneDrive or SharePoint folder as the save location.
- Click the file-type dropdown and choose Excel Workbook (*.xlsx).
- Keep the same file name, so the new copy replaces the old format.
- Click Save and confirm any prompt about replacing the file.
- Check that AutoSave is now available in the top-left corner.
- Ask a colleague to open the file and type one test value alongside you.
- If the workbook uses macros, choose Excel Macro-Enabled Workbook (*.xlsm) instead, so the macros survive.
- The Strict Open XML format looks modern but blocks co-authoring — the plain
.xlsxchoice is the right one. - After converting, test the workbook formulas and charts once, to confirm the conversion kept everything intact.
- Delete the old-format copy from the shared folder, so nobody opens the wrong file by mistake.
Fix 6: Turn Off the Old Shared Workbook Feature
Excel once had a feature called Shared Workbook, now called the legacy sharing mode. It conflicts directly with modern co-authoring: if it is on, live editing is off. The feature hides on the Review tab, and turning it off is the fix. Many old team workbooks still carry it, which is why this fix matters.

- Open the workbook in the Excel desktop app.
- Click the Review tab on the ribbon.
- Click Share Workbook in the Changes group — if the button is missing, the feature is already off.
- Untick Allow changes by more than one user at the same time if it is ticked.
- Click OK and confirm any prompt about removing the shared status.
- Save the workbook to its OneDrive or SharePoint location.
- Ask a colleague to open the file and test live editing with you.
- The legacy feature and co-authoring cannot run together — one must be off, and it must be the legacy one.
- Turning the legacy feature off can remove the change history it kept, so save a backup copy first if the history matters.
- If the Share Workbook button is greyed out, the workbook may be protected or in an old format — check Fixes 5 and 7.
- When the workbook shows a shared-workbook message on open, this fix is the answer, and no other change is needed.
Fix 7: Remove File Password Protection and Restricted Access
Password encryption and restricted access lock a file to one editor at a time, because Excel cannot merge changes into an encrypted or rights-managed file. Only the file owner should remove these settings, and only when the team agrees the file no longer needs them. The settings live under File, then Info, then Protect Workbook.
- Ask the file owner to open the workbook in the Excel desktop app.
- Click File, then Info, then Protect Workbook.
- If Encrypt with Password is active, open it and clear the password box, then click OK.
- If restricted access is active, open the permission settings and choose No Restrictions.
- Save the workbook to its OneDrive or SharePoint location.
- Click Share and confirm the sharing panel now offers live editing.
- Ask a colleague to open the file and type one test value alongside you.
- Only the owner, or someone the owner trusts with the password, should remove protection — never guess or force it.
- Removing encryption is a security decision, so agree it with the team first and consider whether the file still needs protection.
- Sheet protection is different from file encryption, and it does not block co-authoring in the same way — leave sheet settings alone here.
- If the file must stay encrypted, live editing cannot work, and the team should edit in turns instead.
Fix 8: Turn Off Refresh on Open for Tables and PivotTables
Tables and PivotTables can be set to refresh their data every time the file opens. That refresh locks the workbook during opening and blocks co-authoring, because Excel cannot merge changes while a refresh is running. Turning off the refresh-on-open setting for each table and PivotTable removes the block.
- Open the workbook and click inside the first table or PivotTable.
- Open the table or PivotTable design options on the ribbon.
- Click Refresh, then Connection Properties.
- Untick Refresh data when opening the file if it is ticked.
- Click OK to save the connection setting.
- Repeat for every table and PivotTable in the workbook.
- Save the workbook and test live editing with a colleague.
- A workbook with several data connections needs every one checked — a single refresh-on-open setting can block the whole file.
- If external data links behave strangely after this change, our guide to Excel external links not updating covers link faults.
- Turning off refresh-on-open does not stop manual refresh — you can still refresh any table with its Refresh button.
- This fix helps most with workbooks connected to databases or web data, where refresh settings are common.
Fix 9: Close Locked Copies and Check Who Has the File Open
Sometimes the file is genuinely locked because an editor left it open on a computer that went to sleep, or because a crashed Excel left a lock behind. The locked message names the person, and closing their copy releases the file. If the lock persists with nobody open, a stale lock file is the cause.
- Read the locked message carefully and note the name it shows.
- Ask that person to close the workbook fully on their computer.
- Ask them to check for a second Excel window holding the same file.
- If the person is unavailable, wait a few minutes — stale locks often clear on their own.
- Check the OneDrive or SharePoint folder for a lock file beside the workbook.
- If a lock file remains with nobody editing, rename the workbook, then rename it back.
- Open the workbook and confirm it now opens editable, not read-only.
- A lock that names a person who swears the file is closed usually means Excel is still running in the background on their machine.
- If locked-file messages follow you into Word too, our guide to Word file locked for editing covers the same fault in Word.
- Never delete a lock file while someone is genuinely editing — you will create conflicting copies.
- When excel workbook shared editing not working shows as a lock with no one editing, a crashed session left the lock behind, and patience or a rename clears it.
Fix 10: Check OneDrive Sync Status and Storage Space
OneDrive carries every change between editors, so a paused, broken, or full sync looks exactly like broken sharing. The sync icon in the taskbar shows the state at a glance, and the storage check shows whether new changes have anywhere to go. Both checks take a minute and resolve a large share of sync-side faults.

- Click the OneDrive cloud icon in the Windows taskbar.
- Check for a paused, error, or attention message on the sync status.
- If sync is paused, click Resume syncing and wait for it to catch up.
- If an error is shown, click it and follow the OneDrive prompt to repair it.
- Click the OneDrive icon, then the gear, then Settings, and check storage used.
- If storage is full, delete or move files, or empty the OneDrive recycle bin.
- Type a test value in the workbook and ask a colleague whether it appears.
- A red cross on the OneDrive icon means sync has stopped entirely — repair it before testing Excel again.
- Files marked Always keep on this device sync first, so check that the workbook itself is not stuck in a pending state.
- Storage full affects the whole account, so freeing space helps every shared file, not just this workbook.
- Ask every editor to check their own OneDrive status, because one stalled sync hides that person changes from everyone else.
Fix 11: Check the SharePoint Library Checkout Setting
SharePoint libraries can require checkout before editing, which forces single-person editing by design. When checkout is required, the second editor cannot edit until the first checks the file back in, and co-authoring never starts. The setting lives in the library versioning settings, and a site owner can turn it off.
- Ask a SharePoint site owner to open the document library holding the file.
- Open the library Settings, then Versioning settings.
- Find Require Check Out in the versioning options.
- Set Require documents to be checked out before they can be edited to No.
- Click OK to save the library setting.
- Open the workbook from the library and confirm no checkout prompt appears.
- Test live editing with a colleague from the library copy.
- Only a site owner or administrator can change library settings, so this fix needs the right person.
- Turning off required checkout does not delete version history — versions keep working as before.
- If the library must keep checkout for compliance reasons, live editing cannot work there, and the team should use a different library for shared workbooks.
- Check the setting on the exact library holding the file, because each library has its own versioning options.
Fix 12: Try Excel for the Web to Isolate the Desktop App
Excel for the web runs in a browser and supports co-authoring fully. If live editing works in the web version but not in the desktop app, the desktop installation is the fault. If it fails in the web version too, the file, permissions, or storage are at fault. The test splits the problem cleanly in two minutes.
- Open the shared link in a browser, or open the file from OneDrive online.
- Confirm the file opens in Excel for the web, not in the desktop app.
- Ask a colleague to open the same link in their browser.
- Type a test value and watch whether it appears on the colleague screen.
- If live editing works in the browser, the desktop app needs attention — move to Fix 13.
- If it fails in the browser too, revisit Fixes 1, 4, and 10 for the file and storage side.
- Note the result, because it decides whether the remaining fixes target the app or the file.
- The web version needs no install and no update, which makes it the perfect control test.
- If the file will not open at all in the browser, our guide to Excel file not opening covers opening faults.
- Browser extensions that block scripts can interfere with the web version, so test in a plain browser window if the first test is odd.
- A passing web test proves the file, permissions, and storage are all correct, which narrows the fault to the desktop app alone.
Fix 13: Update Excel and Microsoft 365 Apps
Updates include co-authoring fixes, sync improvements, and compatibility repairs. An outdated Excel can fail to merge changes that a current version handles cleanly, and the failure looks like a sharing fault. Updating is quick, keeps your files, and rules out an outdated app in one step.
- Open any Office app and click File, then Account.
- Click Update Options, then Update Now.
- Wait while Office checks for and installs updates.
- Restart Excel when the update finishes.
- Open the workbook from its cloud location.
- Ask a colleague to open the same file and type a test value alongside you.
- If live editing works, the outdated app was the cause — ask every editor to update too.
- Every editor should update, because one outdated app can block the group, as Fix 3 explains.
- If updates are managed by your organisation, ask IT to push the latest Office update to the team.
- A restart after updating matters, because Office finishes the install when the apps close.
- When the fault began after an Office update, a repair in Fix 14 is the next step, because the update itself may have installed badly.
Fix 14: Repair the Office Installation
A damaged Office installation can break co-authoring, sync hooks, and the AutoSave engine, even while ordinary editing works fine. The repair tool replaces damaged program files without touching your workbooks. Quick Repair is fast and offline, while Online Repair is deeper and needs internet.

- Close all Office apps, including Excel, Word, and Outlook.
- Open Settings, then Apps, then Installed apps.
- Find Microsoft 365 Apps or Microsoft Office in the list.
- Click the three dots beside it and choose Modify.
- Choose Quick Repair first, then click Repair and wait for it to finish.
- Restart the computer, open the workbook, and test live editing with a colleague.
- If the fault remains, repeat the steps and choose Online Repair instead.
- Quick Repair takes a few minutes and needs no internet, so always try it first.
- Online Repair downloads fresh program files and takes longer, but it fixes deeper damage.
- The repair does not delete workbooks, templates, or settings, so it is safe to run.
- When excel workbook shared editing not working survives every file-side fix, a damaged Office install is the remaining suspect, and the repair ends it.
Fix 15: Save a Fresh Copy and Share It Again
If the fault survives every fix above, the workbook sharing metadata itself may be damaged. Saving a fresh copy creates clean metadata, and sharing the fresh copy from scratch removes any broken link, permission, or lock state carried by the old file. The content moves across unchanged, because a Save As copies the whole workbook.
- Open the workbook and click File, then Save As.
- Choose the same OneDrive or SharePoint folder.
- Give the copy a clear new name, such as the old name plus
-shared. - Click Save and confirm the new copy opens from the cloud path.
- Click Share and set the permissions fresh for every editor.
- Send the new link to the team and ask everyone to use the new copy only.
- Archive the old file in a separate folder, so nobody edits the wrong copy.
- Tell the whole team to switch to the new copy on the same day, so edits do not split across two files.
- Check formulas, charts, and PivotTables in the new copy once, to confirm the Save As kept everything intact.
- The fresh copy starts with clean version history, so note that the old history stays with the archived file.
- When a fresh copy ends the fault, the old file sharing state was damaged beyond repair, and the new copy is a clean, permanent home.
What to Avoid
- Do not email copies of the workbook around for editing — each copy drifts apart, and merging them by hand loses changes.
- Do not use pirated software, activators, or cracks — they can damage Office and break sync and sharing.
- Do not keep the old Shared Workbook feature on alongside modern sharing — the two modes conflict and live editing loses.
- Do not share a view-only link and expect edits — check the permission level every time you share.
- Do not edit the local copy while others edit the cloud copy — the two versions will never merge.
- Do not delete the OneDrive sync folder or the Office cache by hand — use the proper repair and sync tools instead.
- Do not remove file encryption or restricted access without the owner agreement — it is a security decision, not a quick toggle.
Frequently Asked Questions
Why is excel workbook shared editing not working when the file is already shared?
Because sharing the link is only one link in the chain. The file must live in OneDrive or SharePoint, AutoSave must be on, every editor must use a co-authoring version of Excel, and no blocking feature may be active. A shared link to a local file, a view-only link, or one editor on an old Excel version each break live editing on their own. Work through Fixes 1 to 4 in order, and the missing link will show itself.
How many people can edit the same workbook at the same time?
Microsoft supports many simultaneous editors in co-authoring, and small teams of two to twenty people work smoothly in practice. Very large groups can see slower updates, and heavy PivotTable or macro workbooks update more slowly than simple ones. If a large team sees lag, split the workbook into smaller shared files by topic, or ask editors to work in the web version, which handles simultaneous edits efficiently.
Why do I see a locked message when nobody else has the file open?
The lock is usually stale, left behind by a crashed Excel session or a computer that went to sleep with the file open. Stale locks often clear on their own within a few minutes. If the lock persists, the person named in the message should fully close Excel, including background processes, and the rename trick in Fix 9 clears a stubborn lock. A lock that returns every day points at an outdated Excel version or the legacy sharing feature.
Can I co-author a workbook stored on a network drive?
No. Co-authoring needs OneDrive, OneDrive for Business, or SharePoint Online. A traditional network folder has no service to merge changes, so Excel locks the file for the first editor. Move the file to the cloud with Fix 1, and the network copy becomes unnecessary. If your organisation blocks cloud storage, the team must edit in turns, and the file will show locked messages whenever two people open it.
Does co-authoring work with macros and PivotTables?
Yes, with limits. Macro-enabled workbooks in .xlsm format support co-authoring, but macros themselves do not run in Excel for the web. PivotTables work in shared editing, but tables set to refresh on open block co-authoring until that setting is turned off, as Fix 8 describes. Test the workbook after enabling sharing, and check that PivotTables and macros behave as expected before the team relies on the shared copy.
Will turning off the old Shared Workbook feature delete my data?
No, it does not delete workbook data, formulas, or formatting. It removes the legacy sharing status and can discard the change history that the legacy feature kept. Save a backup copy first if the history matters to you. After turning it off, modern co-authoring takes over, and version history in OneDrive or SharePoint keeps a record of changes going forward.
Conclusion
When excel workbook shared editing not working blocks your team, start with the file location, AutoSave, and editor versions, because those three checks resolve most cases in minutes. Then check permissions, format, and the legacy settings that quietly block co-authoring, and finish with sync, checkout, updates, and a repair if needed. A fresh shared copy ends the stubborn cases where the file sharing state itself is damaged. Finish by editing alongside a colleague and watching each other changes appear, because live updates on both screens are the proof that co-authoring works.
