In SharePoint, why is the "Modified By" column and Version History updating when no changes are made?

rorygilmore2022 21 Reputation points
2022-08-13T00:17:49.05+00:00

When I opened and closed a file in SharePoint, it automatically showed me as the last person who edited the file even though I did not change anything. Why does this happen? Is there a way to prevent this from happening?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,565 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dillon Silzer 54,286 Reputation points
    2022-08-13T02:57:57.377+00:00

    Hi @rorygilmore2022

    You have two options:

    Option 1) Format the Name Column to open files in Read mode

    a) Press the dropdown next to Name > Column settings > Format this column

    230808-image.png

    b) Under Format columns > Advanced mode

    230809-image.png

    c) Enter the following json into the textbox as seen below > hit Save:

    {  
       "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",  
       "elmType": "a",  
       "txtContent": "@currentField",  
       "attributes": {  
          "target": "_blank",  
          "href": "=if(indexOf([$ContentTypeId], '0x0120') >= 0, '?id=' + [$FileRef], @currentWeb + '/_layouts/15/Doc.aspx?sourcedoc='+ [$UniqueId] + '&action=View')"  
       }  
    }  
    

    (cited from https://techcommunity.microsoft.com/t5/sharepoint/default-view-mode-edit-mode-behavior-for-word-and-excel-online/m-p/226287)

    230876-image.png

    d) Refresh the page and you should see:

    230844-image.png

    Now, when you click on a file, the default behaviour will be "read only" in browser. Therefore, there will be no edits to the file and thus, the Modified By/Updating will not be affected.

    -------------------------------------------------

    Option 2) You can train your users to hit the ... or right click > go to Preview instead of clicking directly on the file to open (which opens it in Edit mode by default)

    230826-image.png

    -------------------------------------------------

    If this is helpful please accept answer.


0 additional answers

Sort by: Most helpful