Add Option for Open Readonly
Enable a Open Read-Only option either in browser or with desktop app. Enable change in Browser or desktop app to EDIT the file. This will allow viewing of the document (Excel, word, ppt) without the online version automatically updating it.
Note that Reverting back to previous history version still updates the modified date and modified by shown.
This is critical to for consistency in document management, the doc shows version /date internally but Sharepoint shows another that is not consistent when someone only views the document.