Microsoft KB Archive/141176

= XL7: Last Modified File Date Changes Unexpectedly =

Article ID: 141176

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c

-



This article was previously published under Q141176





SYMPTOMS
In the versions of Microsoft Excel listed at the beginning of this article, when you open a file that was created in an earlier version of Microsoft Excel, the "last modified" date may be changed unexpectedly.



CAUSE
This problem occurs when you open a file that was created in one of the following versions of Microsoft Excel:

5.0 for Windows NT

4.0 for Windows

4.0 for the Macintosh

3.0 for Windows

3.0 for the Macintosh

The date may be changed even if you close the file without saving changes.



WORKAROUND
To work around this problem, use the following steps to make a copy of the file before you open it:


 * 1) Click the Start button, point to Programs, and then click Windows Explorer.
 * 2) Click the file name. (If you want to click multiple files to copy, hold the CTRL key down while you click each file name.)
 * 3) With the file to copy selected, click the right mouse button, and then click Copy on the shortcut menu.
 * 4) Double-click the folder in which you want to place the files.
 * 5) Click the right mouse button, and then click Paste on the shortcut menu.

Now you have a copy of the file with its original "last modified" date.

In order to preserve a copy of the file with the original date, you can either work with the copy of the file, or you can use the file from its original location and replace it with the copy when you're finished.

NOTE: If you choose to place the copy back in the original folder after working with the original file, click Yes when prompted to overwrite the current file. Note that if you do this, you will lose any changes that you made to the file.

Additional query words: 5.00c file date changed datestamp timestamp filedatetime

Keywords: KB141176

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.