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.
Frustrated Windows Developer commented
The option to open a document in edit mode or read only mode by default should have been designed in to the system from the start.
it should not be a popularity contest.
This is a example of bad quality by design.
I hope you are all voting for this one
"Remember, the more votes a suggestion gets, the more likely it is that we’ll do it."
Apparently you only need 10 votes for MS to look at these items on User Voice. Not seeing any movement on this though!
This seems basic and obviously wanted, surprised it hasn't been acknowledged or enhanced after all this chatter.
This should not be that hard, google works like this for years.
Microsoft should add the option to give the Account owner a choice of whether the link opens in Edit or View mode... for heaven's sake....
Jordan Ryder commented
For the document we're using, there is a parameter at the end of the url "action=default". Changing this to action=edit makes the document open in edit mode.
To make it easyer for the older ppl in our organization, I would need the ability to:
Make a "file" (shortcut) that I can place in the folder the old file was located in.
Also, we need to be given the ability to enable it to open directly in normal Excel and not in some browser mode.
If not I will not be able to implement this change and we will be stuck using a normal file on a shared disk, having to call each other to get others to save an logg out of the document in order to make changes
how can this still not be a thing`!?!`?
We are in 2018 not 1998
The default should be configurable. Did I miss something? Is it configurable and I just can't find out how to do that in the myriad of hierarchical menus, options, preferences ?
Eric G. commented
I too would love to see this enabled to allow instant Edit in documents online. Heck even emailed to me from within our own domain we should have instant access. Very frustrating to go backwards. I realize security is a concern, but this is within our own domain! I voted this one up!
Opening excel files in edit mode by default would be a welcomed change, but I haven't seen the change happening yet.
And for those that don't like this change, you could simply protect your sheet/workbook and no one would be able to make a change without first unprotecting them. At least this would be an option and allow everyone to choose what we want to happen. Please don't change back to open in view mode by default again.
Per Ohlsson commented
It looks like they changed the behavior now and open excel files in edit mode but that was not a good solution.
As soon as someone click on a file in a document library it opens in Excel Online in edit mode AND the "Last modified by" and the date is changed even if no changes to the file is made.
If you have a Flow or Alert you will be flooded with alerts and in a SharePoint site with many members this has become a nightmare.
Please change back to Open in view mode again or give us the option to choose what we want to happens.
Rob Prindle commented
It appears no one is reading this. When you click on Tamar's name nothing comes up. Or rather, it says "No Ideas Found" which is interesting.
Our company switch over from Google to Office 365 recently. I heard several "I hate Office 365" comments several times a day from employees.
For Excel Online, it only has 0.01 % capability compared to Google spreadsheet.
The very first thing Microsoft need to do is to allow owner of the excel online doc the capability to hide the "Edit in Excel" feature which can destroy real time collaboration and /or allow the edit online mode default configurable by the owner of the doc please. Can I call or come to work for microsoft to make Excel online a better product?
Rob Prindle commented
Microsoft.... Over two years now. Can you comment? Is this still being considered? Is anyone from Microsoft reading these posts?
Same issue I am having here at my workplace. Users open in read only by default and not able to change or select dropdown menu without going through edit mode first. A lot of communication went through and we still have emails coming back saying that "the worksheet is not working".
The easiest solution I found so far is to go with Google Spreadsheet instead. The same file works on Google with the link in "edit mode" by default.
Not sure how to explain this, but I created a spreadsheet meant for anybody to use, they enter information only in a couple cells and then it automatically returns a ton of information. I've locked all other cells and hidden the (behind the scenes data ) but when I share this by web link, even with edit mode on, it does not work. My only option is to share the excel by attachment but users must download excel app and create an account which most don't and won't do. How else can I upload this to the web and allow people to use it (without saving ) (it's used for gaming stats )
And last, a copy and paste that paste the formulas EXACTLY the same without changing the vlookup range etc. Just copy the formula exactly as written
Request is from 2015. Microsoft, are you sleeping? It's a critical feature with minimal implementation time. How about you wake up? I seriously hate when a product has good vision, good design, but then somebody stupid always forget a thing or two to finalise it. Seriously, your testing department must be made of people who have some serious issues.
Option to Open in Edit Mode if appropriate would make for a more streamlined user experience.