Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. The modified date of the original.xls file is not reset to the original modified time stamp when you save an .xls file in Excel 2007 & Excel 2010

The modified date of the original.xls file is not reset to the original modified time stamp when you save an .xls file in Excel 2007 & Excel 2010

View products that this article applies to.

Symptoms

In Microsoft Office Excel 2007/2010, 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.

↑ Back to the top

Cause

This issue occurs because Excel 2007/2010 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. 

↑ Back to the top

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.

↑ Back to the top

More Information

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
826741 Excel changes Modified date and time when you open the workbook

↑ Back to the top

Keywords: kb, kbexpertisebeginner, kbtshoot, kbharmony

↑ Back to the top

Article Info
Article ID : 948355
Revision : 6
Created on : 8/20/2020
Published on : 8/20/2020
Exists online : False
Views : 337