07-10-2018 03:50 AM
07-10-2018 03:50 AM
How set all documents to open in Read only in sharePoint Online. Few files open in Edit mode while others open in read only mode. This happens in a document library. How to make this uniform.
07-10-2018 08:15 AM
07-10-2018 10:28 AM
No customization have been made to the library. It is normal document library in a Team site.
07-12-2018 08:58 AM
07-12-2018 11:19 AM
08-09-2018 02:55 AM - edited 08-09-2018 02:56 AM
I have the same issue, Excel opens in browser in edit-mode, not read. I cannot change permissions, users should be able to make changes, but not my mistake while reading the documents.
Any tips how to solve this?
10-15-2018 06:55 PM
I am looking for solution for same issue too.
1) If set doc library to require check-out, then need many steps to change a document.
2) if set doc library to NOT require check-out, then anyone can edit the document easily with it opened online. However, since it's default with "edit mode", there are numerous of unintended document changes, generated many versions that should not be there.
The best balance will be to NOT require check-out, BUT open the document in Readonly mode by default and allow user to "explicitly" click the "Edit" button to enable edit mode.
Hope someone can help with this.
10-30-2018 06:36 AM
Even when you use the option 'View in browser' it still opens in Edit mode (if you have editing rights).
As such version numbers are unexpectedly increasing and users save updates by mistake.
The ability to determine in which mode a document will open, is a should have
10-30-2018 06:59 AM
Post this on uservoice! If you have certain documents you want to open in read-only just open them up with the desktop app and choose to always open in read-only mode..The documnt will now always open in read only both online and in desktop client"
10-30-2018 07:08 AM
10-30-2018 06:03 PM
I tested again with the "checkout" mode, below works:
1) check-out the document (I test with Excel)
2) click to open in browser, and edit online, close after edit completed
3) check-in the document
With above steps, then can explicitly edit document online. If want to open in read-only mode, simply open the document in browser without check-out.
Also tested doing multiple times for step "2)", and the Version History will just preserve the last edited version.
This workflow works for me, it may be just not able to allow "multiple editor" (not sure as I did not test this). So, I will stick with the require check-out mode.
10-30-2018 10:59 PM
12-05-2018 07:40 PM
If opening with the online version of the app, it will open in read-only mode if the file is in the old office format (.doc, .xls) otherwise it will open in edit mode. So the default for new office format is always edit mode and can't be changed.
03-03-2020 04:24 AM
@omi kumari - this is the closest feature I've found on User Voice. LMK if you find one with more votes so I can attach to it: https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/38677720-ability-...
05-06-2020 09:17 AM - edited 05-06-2020 09:20 AM
For Excel for Mac: Open in desktop app, in the menu under "File" is the option "Always open as read-only".
Apart from that, please upvote proposal from Cameron just above for folder-wise editing of rights.