read only mode
Excel 2016 workbooks open in read only mode from SharePoint and Edit needs to be enabled everytime.
I open and edit the same workbook 100 times every day. I wish that I could open the Excel without clicking the Edit button every single time.

Excel in the Web now opens all files in edit mode by default. If you continue to experience the file opening in read-only mode it’s possible one of the document authors set the file to open as read-only recommended. This can be changed from the File menu, Info, Protect Workbook and Deselect Always Open Read-Only.
Thanks,
MS Excel Team
53 comments
-
Anonymous commented
Way to go Microsloft! everything great till updates...now back to this read-only mode...for the love of God, please stop doing things like this. Whole facility is at a crawl since they cannot edit existing SharePoint docs which they were editing Friday...
-
Jon Carlson commented
Also wishing this behavior would be changed. Why doesn't Excel 2016 offer the same real-time collaboration in single-license versions that's available through O365 subscriptions?
Until this is fixed, the macro suggested in this thread provides a limited-functionality workaround: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-2016-opens-in-read-only-from-sharepoint/9ed0e6df-ac82-428c-997f-deb86e618927
-
Anonymous commented
So
Very
Annoying!!!
Lay this on top of working in MS Teams, clicking a file and selecting "Open in Excel" (which should be an allowable default behavior!), which then feels the need to tell me that it is opening my workbook in Excel, and I have to click a button to let it continue, and we have 3 clicks plus mouse movement in order to open a workbook, ready to work.
This is ridiculous.
Please fix or provide a registry hack or workaround or something but please stop wasting our time with this Excel nanny. -
Anonymous commented
this is a version issue, not a feature
i have installed office2016 from 365 subscriptions and partner action packs and found different results.
at this point i have only one person with this issue but i cant reinstall his system until the end of the month. then i will have no more users with the read only issue.check your windows and office versions
Mine that work are
Windows 10 Enterprise/Professional
Version 1803
OS Build 17134.165
Microsoft Office 365 Pro Plus Version 1807 Build 10325.20082 click-to-run monthly channel -
Anonymous commented
Please fix this! My users are so annoyed.
-
Maaike commented
For us this was a solution: save the Excel file to Onedrive. In the settings for Onedrive on your windows taskbar you have a tab Office, here you can uncheck syncing Office. We did this on remote desktop with another account, so my account doesn't have this onedrive setting. From here you can use flow to do what you want with the document.
-
Anonymous commented
Please fix this!
-
mizzmarkiw commented
PLEASE, PLEASE, PLEASE allow Excel documents to open ready to edit. PLEASE REMOVE THIS RIDICULOUS ENHANCEMENT
-
Michael Collins commented
This is a **GREAT** enhancement. My users can open Excel without fear of a miss click, miss type, or coffee spill over the keyboard ruining their document due to the auto save feature. I wish there was a specific option to force this in the document library similar to how you can choose Desktop version vs Browser when opening a doc.
I would prefer that even from a trusted site, when no other user was editing the doc my users would still need to have the choice to edit.
-
Anonymous commented
Worst "enhancement" ever! Why would end users want to open files, working in them read only?Please urgently remove this read only default feature!
-
Eoin Sharkey commented
A lot of these comments relate to Excel delivered on Office365, and I understand an update released in around July 2017 may have 'fixed' this behaviour.
At my company, we are not yet ready to embrace SaaS but I did manage to get a trial going with Office 2016 MSI (standalone software). That (MSI) version doesn't get usual features through the channel, but it does get updates (mostly security patches etc), does anyone know if the 'default behaviour' change will ever get included in the MSI updates ?
-
Anonymous commented
i suggest that you fire the person who made this change, since they are somehow unaware of the existence of macros which edit other files? they think everyone loves clicking those yellow header buttons? how could this happen. i suspect there was actually some unrelated issue that was fixed by destroying this critical functionality.
-
Trung commented
I am unable to withdrawn and update data from local excel database to sharepoint. Please release this "enhancement"
-
Sandi Wong commented
I am getting a lot of complaints about this. Please speak to users before coming up with your bright ideas.
-
Anon commented
How to make Microsoft Word better.
1.) Get rid of Read-Only mode.
2.) Make it free again.
-
Please fix this issue! commented
We are having the same issue after latest Office / Windows updates. Please fix this! It's driving us nuts.
-
Anonymous commented
we are having the same issue.
Confusing the users more than they are
any updates?
-
Walter commented
this is really frustrating, IT had to create a new folder and after that I could write in MY files, it was fine for a while and now I have AGAIN the same issue.. I cannot be creating new folders for the rest of my file.. please FIX it...
-
Anonymous commented
Please fix this without any workarounds. This is a very bad feature.
-
Anonymous commented
Please remove this stupid read-only feature.