Does anyone have any idea why using the link on excel opens the file as read-only mode? How can I change the behavior to open as Edit mode?
I checked almost all of the Document Library settings, but so far no luck.
Thank you for reading
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
The setting you want is in Excel, not in SharePoint. Excel will, by default, open documents in Protected View from potentially unsafe locations (that includes SharePoint, but doesn't include local or network drives).
In Excel 2013, the option is in
File > Options > Trust Center > Trust Center Settings > Protected View. You'll want to uncheck the box that says
Enable Protected View for files located in potentially unsafe locations. Depending on your network setup, the setting might be
Enable Protected View for files originating from the Internet.
Assuming you are using SharePoint 2010, go to your document library's Settings, then click Advanced Settings. Find the option for "Default open behavior for browser-enabled documents", and select "Open in the client application". Now, when a user clicks on the document name to open it, they will be able to see that they can edit it and select the "edit" option from the prompt (assuming you are using IE). Here is what that should look like:
Excel (and presumably other office apps) can also give the following error because OneDrive settings. No amount of changing Trust Center settings in Excel will fix it.
We opened this file read-only from the server
You need to untick the following box in the OneDrive settings. Here is more info.
I was having an issue with my SharePoint 2016 on-premise farm Oct2018 CU where excel was opening as read only on the server and users were not able to edit the file. This is using Excel Version 1808 (Build 10730.20262 Click-to-Run). To resolve this we ended up running the following script on our SharePoint farm as directed by Microsoft Support:
$sec = Get-SPSecurityTokenServiceConfig $sec.SuppressModernAuthForOfficeClients = $true $sec.Update()
This seems to have resolved our issue.
See http://support.microsoft.com/kb/2661910/en-us. User may need to have their SharePoint Server Admin make some changes in SharePoint Central Administration.