Forum Discussion
Solved
OneDrive date modified without changing the file
Hi all, We have windows 10 1709 with OneDrive files on demand enabled One of my users have an issue where if he opens and closes a file the changes the date modified. His computer is a relative...
- This is because of AutoSave in the office clients. They continually save as your view them and they will make changes unfortunately sometimes by just looking at them. The only option you really have is to uncheck the option in your OneDrive client so the files don't open directly with office but open locally. It's sort of explained in this article, but this tick box should keep the files opening the old way and not using the auto save functionality.
https://support.office.com/en-us/article/use-office-applications-to-sync-office-files-that-i-open-8a409b0c-ebe1-4bfa-a08e-998389a9d823?ui=en-US&rs=en-001&ad=US
I'm still hoping somebody will solve this annoying feature of OneDrive. As I posted earlier, any Microsoft Office (.docx, .xlsx) file that was created prior to my upgrade to OneDrive has this issue. I recently tested this is another manner. I made two copies of an old Excel file (last modified in 2020) and put one copy inside a OneDrive folder and one copy in my old non-OneDrive Documents folder. When I open the non-OneDrive copy (in the desktop Excel app), nothing changes and the date modified remains 2020. However, when I do the same thing with the OneDrive copy, there is an immediate flashing message at the top of the Excel window saying "Saving" and then the date modified is automatically updated to today's date. If anybody can solve this, I would be grateful. I know this can be fixed, because it doesn't do this on my work computer. As mentioned earlier, AutoSave is turned off in Excel.