Problem with access date

[Marc Allard]

Hello,

I have seen a very strange problem with Excel 2007 : When a user opens an
excel file and closes it immediately, the Excel file is modified (the CRC is
changed), but the archive attribute is not set and the last modification
date is not set too.

Is there a way to solve this problem?

Thank you
Marc

 

[ozgrid.com]

I'm fairly sure the last modification date is only set if you save after a
change.

 

[Bob I]

I suspect it is related to "last access".

 

[Marc Allard]

Hello,

Thank you,
But the problem is that the file is changed, but the archive flag is not
changed (so the backup program doesn't backup the file so when I must
restore the file, the last access date is lost ). Is there a way to force
Excel to work normally (so if the file is changed, the archive flag is
set )?

Thank you
Marc

 

[Bob I]

If the access date is a priority them perhaps a periodic full backup
should be made.

 

[Marc Allard]

Hello,

I am afraid I will have to do like that (or I lose the last access date).
I hope that it is the only case where something like that (the archive flag
not set when a file is modified) happens

Thank you
Marc

 

[Marc Allard]

Thank you
Marc

I'm fairly sure the last modification date is only set if you save after
a change.