4

When I open an excel file, for some reason the last modified date of the containing folder changes to the current time-stamp. I want to disable this, it causes lots of confusion, especially when I order the folders view by modified date.

How can I disabled prevent this issue?

CharlieRB
  • 23,021
  • 6
  • 60
  • 107
Vlad Kucherov
  • 61

4 Answers4

2

You could create a read-only network share and use that for opening such files. Excel won't have any chance then for creating the lock files which in turn change the modification date of the containing folder.

springy76
  • 121
2

The only solution I have found so far is to open Excel via the Start Menu (or launcher of choice). Then go to File>>Open (or Ctrl+o). Choose your file, and click the drop down on the "Open" button to open it as Read Only. Opening it in this manner will keep the folder's Modified Date from updating.

JNevill
  • 1,241
  • 6
  • 12
1

for quick browsing through a few files it was convenient to use the Explorer with preview Pane: it opens any Office file without modifying dates of the file nor the containing folder

markcelo
  • 111
1

The other way to prevent opening an Excel file from changing the folder's modified date is to ctrl-shift right click on file name and select open in protected mode.

Edit: method2 is right click menu on file and click new.

user139301
  • 111