Permission & Access Issues

Troubleshoot the Missing Read Only or Edit Prompt for SharePoint Excel Files

Rana GarciaRana Garcia Nov 14, 2026 868 views

Question details

Determine why a SharePoint Excel file shows an Open or Save bar instead of the expected Read Only or Edit prompt.

Troubleshoot the Missing Read Only or Edit Prompt for SharePoint Excel Files
Product
Microsoft Excel and SharePoint
Device & OS
Windows 10; Windows 7 on the comparison computer
Scenario
A user opens an Excel file from a SharePoint library and expects to choose between read-only and editing modes.
Observed behavior
Windows 10 displays an Open or Save bar, while a different prompt appears on the comparison computer.
Before you start

Identify the SharePoint library and file you are testing, and confirm which account you use to access it. If possible, capture the prompt on the computer where it appears and note how the file was opened.

Solution 1Recommended

Compare Office versions and SharePoint permissions

Use this comparison to identify differences between the working computer and the Windows 10 computer.

The available prompts can vary by Office version, browser, and how the file is opened. A missing prompt alone does not establish that editing is unavailable.

1
Compare Office versions

On each computer, open Excel and select File > Account. Record the Office product name and version under Product Information.

2
Compare the prompts

Open the same SharePoint file on both computers using the same method. Capture a screenshot of the prompt on the working computer and note the browser and account used on each.

3
Check library permissions

Ask a SharePoint owner to open the library settings and check permissions for your account. Confirm whether you have Edit permission for the library and the file.

4
Test editing access

In the SharePoint library, select the file and use Open > Open in browser or Open in app, if available. Check whether you can edit the file rather than relying on the prompt alone.

Compare Office versions and SharePoint permissions
Saving a read-only file: If a file is read-only, being asked to save changes under a new name can be expected. A new copy does not change your permissions on the original file.
Free Microsoft Office alternative

Work with Excel Files in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheets for an easy transition, though WPS does not change SharePoint permissions or restore Microsoft's prompts.

Open and edit compatible Excel spreadsheets in a familiar interfaceSupports Microsoft Excel formats including XLS and XLSXFree and lightweight for everyday spreadsheet workMove existing Office files into your workflow without starting over
microsoft office alternative - wps office

Frequently Asked Questions

Why do I see an Open or Save bar instead of an editing prompt?

The bar may be associated with how the browser opens or downloads the file. In the SharePoint library, try Open > Open in browser or Open in app, and compare the browser and Office versions with the working computer.

How can I check whether I can edit a SharePoint file?

Ask a SharePoint owner to check your account's permissions in the library settings. You can also open the file from the library and see whether editing controls are available.

Where can I find my Excel version?

Open Excel and select File > Account. Look under Product Information for the Office product name and version.

Why am I asked to save a read-only workbook with a new name?

A read-only workbook cannot be overwritten in that mode, so saving changes as a new file can be expected. Ask the SharePoint owner to check your Edit permission if you need to change the original.

Will opening the file in WPS Office change my SharePoint permissions?

No. WPS Office can work with compatible Excel files, but access to the original SharePoint file remains controlled by SharePoint permissions.