SharePoint Online - file modified date updating when user views files in browser

%3CLINGO-SUB%20id%3D%22lingo-sub-265844%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20-%20file%20modified%20date%20updating%20when%20user%20views%20files%20in%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-265844%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20new%20library%20with%20excel%20files%20on%20Modern%20Communications%20Site.%26nbsp%3B%20Files%20open%20in%20browser.%20If%20a%20user%20opens%20the%20file%20in%20browser%20and%20immediately%20closes%2C%20it%20shows%20LAST%20MODIFIED%20a%20few%20seconds%20ago%20by%20that%20user.%26nbsp%3B%20User%20only%20viewed.%26nbsp%3B%20Is%20this%20normal%20behavior%3F%26nbsp%3B%20I%20didn't%20think%20it%20was%20possible%20until%20I%20reproduced%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20changed%20settings%20to%20open%20in%20client%2C%20to%20prevent%20this%2C%20but%20but%20thought%20I%20would%20see%20what%20others%20thought...%20could%20this%20be%20a%20bug%3F%26nbsp%3B%20or%20is%20this%20normal%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-265844%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-265970%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20-%20file%20modified%20date%20updating%20when%20user%20views%20files%20in%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-265970%22%20slang%3D%22en-US%22%3EIt's%20normal%20because%20they%20changed%20the%20default%20open%20to%20%22edit%20mode%22%20when%20opening%20files.%20Which%20honestly%2C%20I%20don't%20like%20for%20this%20exact%20scenario.%20With%20Auto-Save%20turned%20on%20with%20the%20client%20if%20you%20have%20the%20newer%20client%2C%20you%20will%20run%20into%20the%20same%20issue%20as%20well.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20wish%20they%20would%20have%20made%20this%20an%20option%2C%20I%20thought%20there%20was%20an%20option%20to%20choose%20which%20method%2C%20and%20not%20sure%20if%20it%20can%20be%20overwrote%20been%20looking%20for%20the%20message%20center%20post%20about%20this%20change%20to%20see%20if%20they%20included%20that%20option%20or%20not.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1473852%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20-%20file%20modified%20date%20updating%20when%20user%20views%20files%20in%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1473852%22%20slang%3D%22en-US%22%3EHi%20all%3CBR%20%2F%3EI%20am%20the%20same%20problem.%20Any%20solution%20about%20this%20%3F%3CBR%20%2F%3EMax%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1669142%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20-%20file%20modified%20date%20updating%20when%20user%20views%20files%20in%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1669142%22%20slang%3D%22en-US%22%3EHi%2C%20I%20have%20a%20solution%20to%20this.%20In%20Sharepoint%2C%20change%20your%20view%20to%20%E2%80%9CExplorer%20View%E2%80%9D%2C%20then%20simply%20copy%20and%20paste%20the%20file%20from%20there%20to%20the%20destination%20folder.%20This%20will%20preserve%20the%20Modified%20Date%20of%20the%20file.%20Cheers!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1669148%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20-%20file%20modified%20date%20updating%20when%20user%20views%20files%20in%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1669148%22%20slang%3D%22en-US%22%3EYes%20-%20see%20reply%20to%20original%20question%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E
Contributor

I created a new library with excel files on Modern Communications Site.  Files open in browser. If a user opens the file in browser and immediately closes, it shows LAST MODIFIED a few seconds ago by that user.  User only viewed.  Is this normal behavior?  I didn't think it was possible until I reproduced it.

 

I changed settings to open in client, to prevent this, but but thought I would see what others thought... could this be a bug?  or is this normal?

4 Replies
It's normal because they changed the default open to "edit mode" when opening files. Which honestly, I don't like for this exact scenario. With Auto-Save turned on with the client if you have the newer client, you will run into the same issue as well.

I wish they would have made this an option, I thought there was an option to choose which method, and not sure if it can be overwrote been looking for the message center post about this change to see if they included that option or not.
Hi all
I am the same problem. Any solution about this ?
Max
Hi, I have a solution to this. In Sharepoint, change your view to “Explorer View”, then simply copy and paste the file from there to the destination folder. This will preserve the Modified Date of the file. Cheers!
Yes - see reply to original question :)