The modified date of the original .xls file is not reset to the original modified date and time when you save an .xls file with a different name in Excel 2007

In Microsoft Office Excel 2007, you open an .xls file that is located on a network share and then save it with a different name. When you do this, the modified date of the original .xls file is not reset to the original modified date and time as expected.

Note This issue does not occur when the .xls file is located on a local disk or when the file has an .xlsx, an .xlsm, or an .xlsb file format.


CAUSE

This issue occurs because Excel 2007 writes the name of the current user to the header of the file when you open an Excel workbook. This process is required so that other users receive the “file in use” notification. The operating system then updates the last modified date.

Excel stores the original modified date and time in memory so that Excel can restore the original time stamp if you close the workbook without saving changes.


WORKAROUND

To work around this issue, follow these steps:

1. Right-click the file, and then click Copy.
2. In the Windows Explorer window, right-click in a blank space, and then click Paste.
3. Right-click the file, click Rename, and then type the new name for the file.
4. Double-click the file to edit it in Excel.

APPLIES TO
Microsoft Office Excel 2007

——————————————–

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

 


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image