Hide or disable the "Edit in Excel" option when users read or open a document from a SharePoint library in Excel Online
Useers who have ReadOnly permission for a SharePoint Library see the "Edit in Excel" option displayed to them. This will fail when they click since they do not have permission.
reported by a customer on the SPYam Yammer network
You can do this already, and have been able to for some time creating a custom permission level that doesn't include the option of opening files in the client (view the source of documents with server-side file handlers) regardless if the permission is read or edit. I did this for one particular Excel file we had issues when folks were opening in the client.
Is there a resolution for this yet? I need to disable the "edit in excel" option all together for a shared company wide document
Not just users with read-only permission. The document owner needs to be able to disable editing in Excel even for shared edit spreadsheets, forcing them to edit only in the webapp.
If "Workbook sharing" is enabled, you can't open it in the webapp (very stupid).
If you want many people to be able to edit the document simultaneously in the webapp but some muppet opens it in Excel, then nobody else can edit it until they remember to close it. This is terrible.
Alternatively, let the document author specify that the document may only be opened in browser mode so that it doesn't get locked up.
Mumtaz Momin commented
In my organisation we have some excel forms in SharePoint library for users to download. When users with ReadOnly permissions open it in Excel Online they see "Edit in Excel" option. Please change the wording according to user permissions.
Tom Resing commented