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.

Excel changes Modified date and time when you open the workbook


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top


Keywords: KB826741, kbprb

↑ Back to the top

Article Info
Article ID : 826741
Revision : 8
Created on : 2/15/2008
Published on : 2/15/2008
Exists online : False
Views : 1302