Permission & Access Issues

Fix a Shared Excel Workbook That Opens Without Editing or Saving Options

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 868 views

Question details

Users need to edit and save a shared Excel workbook in their browsers.

Fix a Shared Excel Workbook That Opens Without Editing or Saving Options
Product
Microsoft Excel for the web
Device & OS
not provided
Scenario
Company users open a workbook shared with editing permission and need to make changes in the browser.
Observed behavior
Editing or saving options may be unavailable in the browser, or browser editing may return a server error even when the desktop client works.
Before you start

Confirm the affected user is signed in to the correct company account and has the workbook link. Ask the file owner or a SharePoint administrator to help check permissions and restrictions.

Solution 1Recommended

Verify Workbook and Folder Editing Permissions

Use this first when users can open the shared workbook but cannot edit it.

1
Check file access

In OneDrive or SharePoint, select the workbook, choose Manage access, and verify that the affected user or group has permission to edit.

2
Review the sharing link

Select Share, open the link settings, and confirm that editing is allowed for the intended recipients. Apply the settings and send a new link if needed.

3
Check the parent folder

Select the parent folder and choose Manage access to review its permissions. Also check the file itself, because a workbook can have permissions that differ from its folder.

4
Retry in the browser

Have the user open the new link while signed in to the intended company account. If available, choose Editing or Edit Workbook in the browser and test a small change.

Verify Workbook and Folder Editing Permissions
Free Microsoft Office alternative

Work With Excel-Compatible Workbooks in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move existing workbooks into another office suite. It does not fix Microsoft 365 sharing permissions or SharePoint server errors.

Open and edit spreadsheet workbooks in a familiar interfaceCompatible with Microsoft Excel formats, including XLSX and XLSFree and lightweight office suiteMove existing Office documents into WPS Office with minimal setup
microsoft office alternative - wps office

Frequently Asked Questions

Why can someone open the workbook but not edit it?

The user may have view-only access, be signed in with a different account, or be using a link that does not allow editing. Check the workbook's Manage access panel and the Share link settings.

Does sharing the folder with edit access automatically fix file access?

Not always. A workbook can have permissions that differ from its parent folder. Check Manage access for both the folder and the workbook.

Can sheet protection prevent changes even when sharing allows editing?

Yes. Sheet protection can restrict changes to cells, while workbook protection can restrict structural changes. In Excel, open the Review tab to inspect the relevant protection settings.

What should I do if desktop Excel works but browser editing returns a server error?

Record the error text, time, workbook location, and any correlation or request ID. Ask the Microsoft 365 or SharePoint administrator to check service health and relevant server logs.