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
Thanks for your feedback! We’re reviewing your suggestion. I would like to clarify: If sharing through SP the URL parameters are hashed. When a user edit an Excel file and copy the URL for sharing over email the user can choose to change the action to edit.
Remember, the more votes a suggestion gets, the more likely it is that we’ll do it.
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.
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.
We LOVE open in edit mode as a default.
Looking at the other comments, yes, please add a "toggle option". The "Open in Edit" default mode is wreaking havoc on our end-user teams. The "Open in View" mode default is conducive to teams collaborating in a hybrid onsite/remote environment, in working meetings, with both SMEs and reviewers view concurrently. Please add the "toggle option" so a site collection admin, I can restore "Open in View" as soon as possible.
I am continuing to hear of end user frustration with the "Open in Edit" by default change. I am receiving word of users being locked out frequently, unable to update files, having to create and upload multiple versions of the same documents, Word and Excel. I urgently need an option for my site collection to restore "Open in View" as the default.
All those who agree that it should NOT open by default in edit are without a brain. Even excel and word installation open these in edit. Also, to meet req for both worlds here, it simply should be a little setting inside the global configuration of the installation and thats it. What is there to discuss here? Nothing. It's simple, 50% ppl want one way and 50% another way.
I agree with all the coments saying that a document should NOT open in Edit mode. It should be a deliberate action to switch a document in Edit mode to avoid any modification by mistake. (There is no save button).