INTRODUCTION
This article describes the Microsoft Office Excel 2003 issues that are fixed in the Microsoft Office Excel 2003 post-Service Pack 1 hotfix package that is dated August 20, 2004.
back to the topIssues that the hotfix package fixes
This hotfix package fixes the following issues:
817578 You cannot change a link path when an Excel Add-in is not loaded
829220 CMW settings are not retained by Excel 2003
870757 Multiple grand totals are missing after you set the Excel97Subtotals Windows registry value
839634 When you open a workbook in Excel 2003 that was created in Excel 2000 or earlier, the program may appear to stop responding
This hotfix package also fixes the following issues that were not previously documented in a Microsoft Knowledge Base article:
- When you configure the Microsoft Visual Basic Applications (VBA) Workbook_Open event that targets an Excel 2003 workbook with a custom property configured, the event may not run.
- If you configure the VBA EnableSelection property programmatically, the EnableSelection property is not saved in an Excel 2003 workbook.
- MSQuery may insert an additional space in a SQL statement if you are connected to an Oracle database. Additionally, you may receive a syntax error when you try to modify the query.
-
When you move or edit data labels on an Excel 2003 3-D area chart, the text in the labels may disappear.
- When you programmatically create a query in MSQuery that contains a parameter query, Excel 2003 may quit unexpectedly, and you may receive the following error message:
Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
If you view the details of the error message, you receive an error signature that is similar to the following: Application Name Application Version Module Name Module Version Offset
----------------------------------------------------------------------------
Excel.exe 11.0.6205.0 Excel.exe 11.0.6205.0 002d2a30
-
When you try to import data by using the Excel 2003 Data Import Wizard, Excel 2003 may incorrectly identify the code page (language setting) of the document that you are trying to import.
- When you use a document that contains a link that points to a Microsoft Excel workbook, the Excel taskbar button may not flash to notify you that there is a confirmation dialog box opened in Excel 2003 that requires input.
- If you try to move a data validation input message to you modify a cell, Excel
2003 may unexpectedly quit or stop responding, and you may receive the following error message:
Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.
- When you click an option in an AutoFilter list that contains VLOOKUP function as one of the options, Excel 2003 may unexpectedly quit or stop responding. Or, the AutoFilter lists may stop functioning even though Excel 2003 still responds.
-
When you try to send an Excel workbook by clicking the Send to mail recipient option on the File menu, the Subject box in the e-mail message is missing information if the subject contains a number sign (#) character.
- When you print a chart or use Print Preview, Excel 2003 may not print an attachment that contains text in a text box if the text is not set to change size with the chart.
- If you
modify the code in a VBA module and then try to calculate a range, a custom function returns "#NAME?" (without the quotation marks).
- The Workbooks.Open method in VBA may silently fail if it is called from a worksheet function.
- Excel 2003 may stop responding if you use the Find and Replace feature in an array formula.
- The Negative Currency format in Excel 2003 is incorrect when you use the French (Canada) regional setting in Microsoft Windows XP Service Pack 1 (SP1).
- The data that is in Excel 2003 cells that contain formulas that include the
RealTimeData (RTD) function may not be refreshed as expected after you
run another program. This issue occurs if the other program that you
run uses timer events and passes a timer ID value to the Microsoft Windows API SetTimer()
function for a windowless timer. If the timer ID
value is the same as the timer ID value for the windowless timer that
Excel 2003 uses for the RTD function, the other program takes control of the
windowless timer from Excel 2003. This action stops the RTD function from
refreshing the cell data.
-
If a signed trusted Excel add-in is loaded in Excel 2003, and the Trust all installed add-ins and templates option is disabled, the Excel add-in may not load.
- Excel 2003 may stop responding after you recalculate values on a worksheet by pressing SHIFT+F9.
- You receive the following error message when you try to open an Excel 2003 worksheet while your computer is logged on to an RDP session:
File_Name.xls cannot be accessed
- When you try to open a tab-delimited data file in Excel 2003 by using the Import Data Wizard,
the spaces and the line breaks may not be displayed as expected, and miscellaneous characters may appear where the line breaks should be.
-
When you programmatically protect an Excel 2003 workbook, PivotTables may become corrupted. You may receive the following error message the next time that you try to open the file:
Unable to Read file
- You receive the following error message if you clear merged cells programmatically and then try to paste special values in the range:
The operation requires the merged cells to be identically sized
back to the topMORE INFORMATION
Service pack information
This problem was first corrected in Office 2003 Service Pack 2.
To resolve this problem, obtain the latest service pack for Office 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
870924 How to obtain the latest service pack for Office 2003
Hotfix information
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Microsoft Office 2003 service pack that contains this hotfix.
To resolve this problem immediately, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
back to the topPrerequisites
The following list contains prerequisites for the hotfix package:
- The optimized version of this hotfix is a post-Office 2003 Service Pack 1 (SP1) hotfix. To install the hotfix, you must have Office 2003 SP1 installed.
For more information about Office 2003 SP1, click the following article number to view the article in the Microsoft Knowledge Base:
842532
Description of Office 2003 Service Pack 1
- The full-file version of this hotfix is also the administrative version of this hotfix. You can install this version of the hotfix on a computer that is running Office 2003 with Microsoft Office 2003 Service Pack 1 (SP1) installed or on a computer that is running Office 2003 without Office 2003 SP1 installed. However, we have tested this hotfix more extensively on a computer that is running Office 2003 with Office 2003 SP1 installed than on a computer that is running Office 2003 without Office 2003 SP1 installed. If you install this hotfix on a computer that is running Office 2003 without Office 2003 SP1 installed, some file conflicts might occur. We support this configuration, but we do not recommend this configuration.
back to the topRestart information
You do not have to restart your computer after you apply this hotfix.
back to the topHotfix replacement information
This hotfix is replaced by a later hotfix.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
885845
Description of the Excel 2003 post-Service Pack 1 hotfix package: September 22, 2004
back to the topRegistry information
You must create or modify a registry key to use the one of the hotfixes that this package contains.
For more information about the registry keys that must be created or modified, click the following article number to view the article in the Microsoft Knowledge Base:
870757
Multiple grand totals are missing after you set the Excel97Subtotals Windows registry value
back to the topHotfix file information
This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain of all the files that you must have to fully update a product to the latest build.
The global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the
Time Zone tab in the Date and Time tool in Control Panel.
Download information
Date Time Version Size File name
--------------------------------------------------------------------------
23-Aug-2004 15:29 5.0.2919.6304 5,509,664 Office2003-kb840316-glb.exe
Microsoft Windows Installer .msp file information
Date Time Size File name
--------------------------------------------------------
20-Aug-2004 21:46 8,391,168 Excelff.msp
20-Aug-2004 11:44 2,123,776 Excelop.msp
After the hotfix is installed, the global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table:
Date Time Version Size File name
--------------------------------------------------------------
18-Aug-2004 07:30 11.0.6400.0 10,082,496 Excel.exe
Additional notes:
- For additional information about how to install this hotfix, see the Readme.txt file that is included in the hotfix package.
- For additional information about the differences between the two .msp files, see the "Strategies for Updating Office 2003 Installations" topic. To see this topic, visit the following Microsoft Web site:
back to the topREFERENCES
For more information about the terminology that Microsoft uses when correcting software after it is released, click the following article number to view the article in the Microsoft Knowledge Base:
824684
Description of the standard terminology that is used to describe Microsoft software updates
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
back to the top