Excel Updating Modified Date When I Don't Save File

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

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

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

I saw this happen a longgggggg time ago.

I think we were using xl97 at work and it would only happen if I opened (and
then closed) a file stored on a remote network. Local files would have the
date/time stamp reverted back.

But the problem (and I agree that it's a problem) went away one day. I didn't
do anything different. I always assumed that it was a network bug/patch that
was fixed by our IT staff.

Does this problem happen to files stored on your C:?

(I don't have any suggestion, but if only happens on network files, then maybe
you can complain to the IT folks???)

Charles wrote:

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

--

Dave Peterson

One of my customers is experiencing the same problem. Upgraded from 2003 to
2007, and now the date modified is changed to current whether saved to file
or not. Running compatibility mode, Excel requests to save, even though the
file was opened only for viewing. It would be very nice to have a solution.

"Dave Peterson" wrote:

I saw this happen a longgggggg time ago.

I think we were using xl97 at work and it would only happen if I opened (and
then closed) a file stored on a remote network. Local files would have the
date/time stamp reverted back.

But the problem (and I agree that it's a problem) went away one day. I didn't
do anything different. I always assumed that it was a network bug/patch that
was fixed by our IT staff.

Does this problem happen to files stored on your C:?

(I don't have any suggestion, but if only happens on network files, then maybe
you can complain to the IT folks???)

Charles wrote:

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

--

Dave Peterson