XL97: Opening Excel File on MAPI Folder Updates Modify Date

ID: Q247903

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Outlook, versions 2000, 97, 98

NOTE: The information in this article applies to the Japanese version(s) of Excel.

SYMPTOMS

When you open a Microsoft Excel 97 file posted on MAPI folders in Microsoft Outlook (such as Personal Folders or Exchange Public Folders) the modified date/time is updated even if you make no modifications.

CAUSE

When you open an Excel file on the NTFS file system, Excel 97 updates the modified time of the file to the current time. However, if you do not modify the Excel file, Excel puts back the original modified time of the file.

When you open an Excel file on a MAPI folder, Outlook creates a temporary file and folder for the Excel file and remembers the modified time of the temporary file. Outlook then starts Excel 97, which updates the modified time for the file. Even if you close the Excel file without modifying it, Excel notifies Outlook that the file is closing before it puts back the original modified time of the file. Outlook may then infer the file is updated, and so it updates the modified time of the Excel file on the MAPI folder to the current time.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words:

Keywords :
Version : WINDOWS:2000,97,98
Platform : WINDOWS
Issue type : kbbug