Mar 26 2019 11:13 AM
Is there a way to prevent this? Users in our environment typically open the excel files in the browser simply to view the file and not change anything. Somehow, SPO is detecting this as modification. How can I (without restructuring the entire sites groups/permissions) prevent the modified by from changing to the user who last access the file simply to view it?
Thanks!
Mar 26 2019 11:18 AM - edited Mar 26 2019 11:20 AM
As far as I know it is not possible to prevent the modified by from changing to the user who last access the file simply to view it.
Thanks
Robin Nishad
Nov 02 2022 02:27 PM
Nov 03 2022 07:22 AM
@ChristineZ24
Not that I am aware. Would be very useful tough.
There is a workaround: see https://answers.microsoft.com/en-us/msoffice/forum/all/default-view-read-or-edit-when-opening-excel-...
Apart from the changed modified field you also end up with a new document version that also consumes storage quota.
May 16 2023 09:55 AM
@Paul_HK_de_Jong Wow this seems crazy. You are sharing with a large group working on a project and when you want to look for files with new info, you can't. You sort by modified and you just get a bunch of last looked at files, not files with new updates?