Older MSOffice files changed upon opening


#1

Hi,

We have a folder shared amongst a wide team containing many files and filetypes.

When someone opens an old-format Microsoft Office file on Windows (ppt .xls) the client detects this and a 'Person changed ' notification appears on the server, even if the user does not edit or save the file.

Newer format Office files (xlsx pptx etc.) don't exhibit this behaviour.

The modification date/time changes when you open the file ... although it then changes back afterwards:

Modified: 28 June 2017, 11:54:43 [ before opening file ]
Modified 29 June 2017, 14:14:25 [ while file is open ]
Modified: 28 June 2017, 11:54:43 [ after closing file ]

I assume it's because of this: https://blogs.msdn.microsoft.com/pranavwagh/2006/08/14/excel-changes-last-modified-date/

"This problem occurs because when you open an Excel workbook, Excel writes the name of the current user to the header of the file. This is necessary so that other users receive the "file in use" notification. The operating system then updates the last modified date. Excel stores the original Modified date and time in memory so that it can restore the original timestamp if you close the workbook without saving changes."

Is this a problem for everyone, or is there a configuration setting which can help?

Thanks