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.
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
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.
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
OS Build 17134.165
Microsoft Office 365 Pro Plus Version 1807 Build 10325.20082 click-to-run monthly channel
Please fix this! My users are so annoyed.
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.
Please fix this!
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.
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 ?
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.
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.
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.
we are having the same issue.
Confusing the users more than they are
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...
Please fix this without any workarounds. This is a very bad feature.
Please remove this stupid read-only feature.
Elle Gasdorf commented
I need to open several workbooks at a time from Sharepoint, so I could refer to files side by side. I used to be able to go to file, recent, and select the file with the Sharepoint link and open. Now it only opens a read-only file, with no checkout option. Also, when you close a workbook, it closes Excel. This is a horrible step backward. Please fix!