View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Excel Updating Modified Date When I Don't Save File

You must be looking at the time-stamp when the file is still open.

Modified time changes to the time the file is opened but reverts back to the
original if you close it without saving the file.

Also modified time is an OS feature... which tracks the creation, accessed
and modified time (in Windows...)

"Charles" wrote:

Hi,

I have converted to Office 2007 and now with some of my Excel files when I
use them and don't save them the modified date changes to the time I close
the file. I don't think this should happen. It causes me problems because I
wan't the modified date to represent the last time I made changes to the
file. Can someone tell me how I can stop this updating of the modifed date
when I don't save from happening? (It doesn't seem to happen for all files
and doesn't seem to happen all the time).