Excel changes Modified date and time when you open the workbook

Article translations Article translations
Article ID: 826741 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you view the properties of a Microsoft Excel workbook, the Modified date and time may temporarily change even when you make no changes to the file. You may notice this behavior when you open the file in Excel and then click Properties on the File menu, or when you view file details in Microsoft Windows Explorer.

CAUSE

This problem occurs because when you open an Excel workbook, Excel writes the name of the current user to the header of the file. This is necessary so that other users receive the "file in use" notification. The operating system then updates the last modified date.

MORE INFORMATION

There is a binary difference between the file contents before you open and close an Excel workbook without saving it and after you open and close an Excel workbook without saving it.

The issue does not apply to the following file formats in Microsoft Office Excel 2007:
  • .xlsx
  • .xlsm
  • .xlsb

Properties

Article ID: 826741 - Last Review: February 15, 2008 - Revision: 6.2
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
Keywords: 
kbprb KB826741

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com