Ability to open Excel Online in Edit mode by default or link to edit mode
Currently I need to click Open on Excel Online or Open Excel if I want to edit a workbook. If I have edit permissions, it should open in edit mode by default on Excel Online. At the very least we should be able to add a URL argument to allow it
Open in “Edit mode by default” is available for Excel files stored on SharePoint Online and OneDrive for Business.
You'll need to change the workbook to unprotected in your files. Otherwise the opposite you can go to File>Info>Protect Workbook. I'm not sure if this feature has been available for a while but I didn't know it until now.
No I disagree. The need is the opposite. STOP opening excel online in default mode of edit! This is an nightmare from an admin of governance perspective. I cant tell when someone actually edited or when they just viewed the document. This is a serious concern and should be treated as a bug NEEDING to be fixed immediately.
make the attached file editable
Steve Berardi commented
You can do this with the link.
Somewhere in the link you will see this string:
Change &action=default& to &action=view& for reader view
Change &action=default& to &action=edit& for edit view
This is definitely a must and should be available.
I read a post/article that said to change the default when opening a document on SPO, go to Site Settings/Site Collections Administration/Site Collections Features/Open Document in Client Application by Default and either activate or deactivate.
Not sure if this is will resolve your issue, but it helped me.
Please can we have an option in the document to default to either view. I have a situation where we have some complex VBA which can only be used in Desktop mode, meaning only one person can be editing at a time. We'd like the online version to open to view by default so that if someone needs to edit it's more likely that the document is free to use.
Would love to have this as a user defined set -- I am an accountant and always to open Excel on the desktop version because of all the missing functionality and addons :-/
Margaret Plack commented
I do not like the Edit mode as default. How can I elect to NOT have this as default??? I much prefer to decide how I want to use each document when I open it. Also if I am working in the Edit mode - which is now my default :-( and my internet goes down even briefly (it often cuts in and out) then I lose my work. HELP
This is crazy...my work partner can open Word directly in "read" or a Create-type mode, yet mine only opens in "edit" mode. we sit 10 feet from one another...unbelievable!
The Mighty Mixsnew commented
What's the point of sharing a document? Editing or viewing? If you CREATE a link with the option to EDIT, then it should be EDITABLE no matter the tool or resource being used. If you want to create a link with READ-ONLY, then it will be READ-ONLY. That's your toggle. That's your setting at the document owners level.
Right now, this is stupid. Not all users have Excel to edit the shared file. That's what made Excel Online so attractive to my mobile users.
Kathy Lynch commented
If you do this, like was done for Word recently, please make this a setting at the Library/List or Site level, so that the site owners can decide based on their users.
After having the default be to read only and opt to edit, changing this inadvertently leads to unexpected edits (errors) in the docs. Yes, versioning allows you to go back, but if you don't even realize you did it, it makes recovery harder.
Don't make a radical user change like this without giving the option to use or not use.
I cannot vote against this or demote this!
Default on click must be Read. This default to open in edit mode IS causing us massive problems. Users should elect to edit a document. Alternatively allow Administrators to decide what is the default for each library.
Agree to this suggestion!
Even though users can always click the button to edit, but adding one more step is pushing users one step away, especially when there is a direct competitor called "Google Sheet" which is very easy to access.
It is quite annoying when people want to edit and a warning pops out, people will just think this is stipid since the person already got the permision to edit in the first place.
I sometimes have the impression that Microsoft does not care about its users, it is the problem of the monopoly, only the aspect of business account henceforth, we passed the great engineers who created SharePoint 2010?
Shankar Gurav commented
As JE Puhr suggested site collection administrator needs to have setting to toggle this setting. its frustrating to see the document status is modified even though it was intended to ready purpose only.
We have found a workaround: just set open file in client application by default for the library, and the file is opened in Excel as Readonly, and users can still use filters without edit. Could help in some situations
I would like to be able to set an attribute on specific files that would allow them to only be edited in the web browser. This would be a great benefit in the case of files shared with a large number of users.
JE Puhr commented
We need a toggle - Edit by Default is causing locked files and frustrated users. Opening in View by default provides a safeguard. Let the choice be up to the site collection administrator to support how an organization prefers to work. Opening in Edit by default is also an accessibility concern as users can make an inadvertent edit and not realize it.
My doc library is now also completely disrupted since user can edit directly.
I am using a library with Version control and approval;
As soon as a user open an Excel, and click a cell, the document status will change to "Draft" even though no modification were added...What smart is that ?
Please enable a "toggle option" so We can define the opening behavior, whether "Edit" whether "Read Only", thanks.