Microsoft KB Archive/826741

= Excel changes Modified date and time when you open the workbook =

Article ID: 826741

Article Last Modified on 11/4/2005

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-





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 &quot;file in use&quot; notification. The operating system then updates the last modified date. Excel stores the original Modified date and time in memory so that it can restore the original timestamp if you close the workbook without saving changes.



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.

Additional query words: OFFXP

Keywords: kbprb KB826741

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.