View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
charles charles is offline
external usenet poster
 
Posts: 124
Default Excel Updating Modified Date When I Don't Save File

No, the time stamp remains after I have closed the file. It only happens
with Excel files, not Word for example.

"Sheeloo" wrote:

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).