Excel 2007 Date Modified

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mcleester - 25 Jul 2007 14:44 GMT

When I open a document created in a previous version of Excel (*.xls) in
Excel 2007 and then save it to a DIFFERENT location, the "Date Modified"
property in Windows of the ORIGINAL file is changed.

Why does this happen? I haven't changed the original file. Is there any
way to fix it? Am I actually changing the file by opening it? I found this
documentation that says Excel is supposed to write back the original
timestamp.

http://support.microsoft.com/kb/826741

Perhaps this is a bug? There might be some incompatibility with doing so
between the programs? It is important to me to retain the timestamps of the
original files for reporting/control purposes. Any help is much appreciated!

Reply to this Message

Jim Rech - 25 Jul 2007 15:16 GMT

I just opened an old XLS in Excel 2007. Its modified date stamp updated to
the current date and time. I saved it in another location. The original
file's date stamp was set back to what it was originally. So seems okay
here.

Signature

Jim

| When I open a document created in a previous version of Excel (*.xls) in
| Excel 2007 and then save it to a DIFFERENT location, the "Date Modified"
[quoted text clipped - 10 lines]
| between the programs? It is important to me to retain the timestamps of the
| original files for reporting/control purposes. Any help is much appreciated!

Reply to this Message

mcleester - 25 Jul 2007 15:26 GMT

Thanks. It is definitely happening to me. I thought it might have something
to do with macros in the workbook, so I created a workbook without any
macros. I still experienced the same phenomenon.

> I just opened an old XLS in Excel 2007. Its modified date stamp updated to
> the current date and time. I saved it in another location. The original
[quoted text clipped - 18 lines]
> | original files for reporting/control purposes. Any help is much
> appreciated!

Reply to this Message

Bernard Liengme - 25 Jul 2007 15:49 GMT

When Excel opens a file created by a previous version is does a
recalculation so when it is saved it quite correctly gets a new modified
date. Not a behaviour unique to XL2007; XL2003 will do it when you open an
XL97 file.
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> When I open a document created in a previous version of Excel (*.xls) in
> Excel 2007 and then save it to a DIFFERENT location, the "Date Modified"
[quoted text clipped - 13 lines]
> original files for reporting/control purposes. Any help is much
> appreciated!

Reply to this Message

mcleester - 25 Jul 2007 16:02 GMT

Yes, but I don't want it to change the original file (I saved in a different
location). Is there any way to do that?

> When Excel opens a file created by a previous version is does a
> recalculation so when it is saved it quite correctly gets a new modified
[quoted text clipped - 18 lines]
> > original files for reporting/control purposes. Any help is much
> > appreciated!

Reply to this Message

Bob I - 25 Jul 2007 18:37 GMT

Don't use Excel to Save As, simply copy the file in the desired location
using Windows Explorer.

> Yes, but I don't want it to change the original file (I saved in a different
> location). Is there any way to do that?
[quoted text clipped - 22 lines]
>>>original files for reporting/control purposes. Any help is much
>>>appreciated!

Reply to this Message

Jim Rech - 25 Jul 2007 16:22 GMT

>>When Excel opens a file created by a previous version is does a
>>recalculation so when it is saved it quite correctly gets a new modified
>>date.

Quite right that it does a calc. But this does not cause a save (of the
original file) for me. Does it for you in Excel 2007?

Signature

Jim

| When Excel opens a file created by a previous version is does a
| recalculation so when it is saved it quite correctly gets a new modified
[quoted text clipped - 18 lines]
| > original files for reporting/control purposes. Any help is much
| > appreciated!

Reply to this Message