Excel Changes last-Modified Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry Baker - 23 Jan 2006 22:51 GMT

Is there a way to stop Excel from changing the last-modified date of
every file that is opened (even when no changes are made and save is
never pressed)? This is really screwing us up in the office because we
are looking through a ton of old files for one that was last-modified on
a certain date. When we open a suspect file it CHANGES THE DATE!!!! Make
it stop.

Thanks.

Reply to this Message

Bob Phillips - 23 Jan 2006 23:05 GMT

It is only temporary, if you don't save it it reverst back when you close
it.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> Is there a way to stop Excel from changing the last-modified date of
> every file that is opened (even when no changes are made and save is
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message

Jerry Baker - 23 Jan 2006 23:11 GMT

> It is only temporary, if you don't save it it reverst back when you close
> it.

Perhaps it is a problem with network drives, but it does not revert.

Reply to this Message

Jerry Baker - 23 Jan 2006 23:16 GMT

>> It is only temporary, if you don't save it it reverst back when you close
>> it.
>
> Perhaps it is a problem with network drives, but it does not revert.

Indeed, locally it does not occur (it does revert).

Reply to this Message

Jerry Baker - 23 Jan 2006 23:13 GMT

> It is only temporary, if you don't save it it reverst back when you close
> it.

Not only does it permanently change the last-modified date, but it
permanently changes the creation date to the opening date/time as well.

Reply to this Message

Dave Peterson - 24 Jan 2006 00:13 GMT

We had this happen a longgggggggg time ago. But the problem went away after a
while. I always thought that the IT folks did something to the network to fix
it. (But I have no idea what that may have been.)

> Is there a way to stop Excel from changing the last-modified date of
> every file that is opened (even when no changes are made and save is
[quoted text clipped - 4 lines]
>
> Thanks.

Signature

Dave Peterson

Reply to this Message

kcc - 24 Jan 2006 03:30 GMT

I've changed some files to read only just to stop this from happening.
It seems to be time dependent or dependent on some other event
on the network because it only happens about 10% of the time.
I can't figure out a pattern.
kcc

> We had this happen a longgggggggg time ago. But the problem went away
> after a
[quoted text clipped - 10 lines]
>>
>> Thanks.

Reply to this Message

Michael Bednarek - 24 Jan 2006 10:45 GMT

>Is there a way to stop Excel from changing the last-modified date of
>every file that is opened (even when no changes are made and save is
>never pressed)? This is really screwing us up in the office because we
>are looking through a ton of old files for one that was last-modified on
>a certain date. When we open a suspect file it CHANGES THE DATE!!!! Make
>it stop.

You could use a dedicated viewer to view the Excel files. QuickView
(Plus) springs to mind, fmView also works crudely; there are probably
more.

I would not recommend to install the Microsoft Excel Viewer
(<http://office.microsoft.com/downloads/2000/xlviewer.aspx>): I
distinctly remember how it screwed my existing Excel installation.

Signature

Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Reply to this Message