Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


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.


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. 


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

  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.

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!