An Excel lock message can stop a purchasing list, staffing worksheet, or project budget at an inconvenient moment. For a Bay Area business with people working across offices and job sites, the temptation is to make another copy and keep moving.
Start by identifying the workbook and the reported editor or possible open session. A rushed workaround can leave the team editing different files without agreeing which one is authoritative.
Read the message before changing anything
Record the exact error, the time, and any name shown. Distinguish the person currently editing from the person responsible for the workbook. They may be different people, and a name in a lock message does not establish who can approve changes to access or workflow.
If the message names you, check your other devices and open Excel windows. Save your work and close the workbook normally wherever you have it open. Microsoft recommends allowing a few minutes for the server to release a lingering lock. If it names a colleague, ask whether they are still editing. Reading the file without editing may be enough while you wait. Microsoft’s file-lock guidance explains these first checks.
Do not force another person’s Excel session to close or delete temporary lock files. If normal closure does not help, leave the workbook in place and involve IT.
Confirm everyone is opening the same workbook
Ask the workbook owner for the existing approved shared link. Compare the file location, not just the filename. An emailed attachment or a downloaded copy with the same name is a separate working copy, not evidence that everyone is collaborating on the original.
For supported coauthoring, Microsoft documents OneDrive, OneDrive for Business, or SharePoint Online storage and .xlsx, .xlsm, or .xlsb formats. Open the shared workbook from its link rather than circulating attachments. Desktop participants need a supported Excel version; Excel for the web is another option. See Microsoft’s coauthoring setup instructions.
A conventional network-drive path or ordinary local folder is not a supported location for this cloud coauthoring workflow. Strict Open XML Spreadsheet format is also excluded. Do not move a business workbook into a personal cloud account or convert its format simply to make the warning disappear. Ask the owner and IT to choose an approved approach, particularly when macros or business integrations are involved.
Check the app that opened it first
One participant using an Excel version that lacks coauthoring support can lock out colleagues using supported versions. Include the current editor’s app version when asking IT to investigate. See Microsoft’s lock troubleshooting guidance.
Have the current editor save and close normally before testing the approved link in the browser. Note whether browser access works and desktop access fails. That comparison gives support a useful starting point without changing the workbook or its permissions.
Keep protections in place
A protected cell, a view-only link, and a workbook held open by another session require different responses. Excel has separate controls for worksheet contents, workbook structure, and editable ranges, as Microsoft’s protection overview explains.
Do not remove passwords, sensitivity labels, worksheet protections, or access restrictions as a general troubleshooting step. Ask the responsible owner whether you should have editing access and which parts you may change. If a protection or workbook feature limits collaboration, IT should assess the intended workflow with that owner.
Agree on a safe handoff
Before the next person edits, ask the current editor to confirm that their changes saved successfully. If they see an upload or save error, pause the handoff and report it rather than treating the file as ready.
Once editing resumes, keep AutoSave enabled where supported and appropriate for the shared workflow. Coordinate changes to macros separately from simultaneous editing; Microsoft recommends editing VBA code while working alone. Its coauthoring best practices also warn that moving or deleting shared files can disrupt colleagues.
For an unresolved lock, send support this short checklist:
- The approved file link or location and exact error text.
- The name shown, affected users, and time of the failure.
- Excel version, device, and whether browser access works.
- Whether the current editor confirmed saving and normal closure.
- Any save, upload, or sync warning, with confidential worksheet contents excluded from screenshots.
For help investigating recurring software or access problems, explore VFIX’s IT help desk and support. A clear account of who opened which file is a better starting point than a forced unlock.