Excel 2007 Date Modified

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

--
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"
| 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!
 
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.
 
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
 
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
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?

--
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
| date. Not a behaviour unique to XL2007; XL2003 will do it when you open an
| XL97 file.
| best wishes
| --
| 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"
| > 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!
|
|
 
Don't use Excel to Save As, simply copy the file in the desired location
using Windows Explorer.
 
Back
Top