Microsoft KB Archive/903240

= Description of the Excel 2003 post-Service Pack 2 hotfix package: November 7, 2005 =

Article ID: 903240

Article Last Modified on 11/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2003

-





SUMMARY
Microsoft has released the Excel 2003 post-Service Pack 2 hotfix package for Microsoft Office Excel 2003.

This article describes the following items about the hotfix package:


 * The issues that the hotfix package fixes.
 * The prerequisites for installing the hotfix package.
 * Whether you must restart your computer after you install the hotfix package.
 * Whether the hotfix package is replaced by any other hotfix package.
 * Whether you must make any registry changes.
 * The files that the hotfix package contains.



INTRODUCTION
This article describes the Office Excel 2003 issues that are fixed in the hotfix package that is dated November 7, 2005.

Issues that the hotfix package fixes
This hotfix package fixes the following issues.

887964The LINEST function returns an incorrect value in Excel 2003

902062 Part of a worksheet is missing when you run a VBA macro that uses the ScreenUpdating property to unhide a worksheet after you close the Document Recovery task pane in Excel 2003

906679 When you use the &quot;Open and Repair&quot; option to repair a worksheet, the DDE links are removed from the worksheet in Excel 2003

This hotfix package fixes the following issues that were not previously documented in a Microsoft Knowledge Base article:  When you open a saved workbook that contains a hidden window in Excel 2003, you may experience the following symptoms:  The current workbook may remain as the active workbook. The saved workbook may open as an inactive workbook in the background.  You open an Excel 2003 file in a Microsoft Windows SharePoint Services document library. This file contains a link to another file. However, when you open the Excel 2003 file, the link is not updated. This issue may occur when the document library folder name contains a space.

 You edit an Excel 2003 workbook that is embedded as an icon in a document of another program. If you insert a chart as a new sheet, the chart has a size of zero (0). Additionally, the chart appears very small.

 When you programmatically count the dependent cells of a cell that is in a data table more than one time, the macro does not count the cells. Additionally, you receive the following error message:

Run-time error '1004':

No cells were found.

</li> When you recalculate a workbook in Excel 2003, Excel 2003 may unexpectedly quit. Additionally, you receive the following error message:

Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.

This issue may occur if all the following conditions are true:  You disable the macros when you open the workbook.</li> You use the HLOOKUP function or the VLOOKUP function to search for a value in a table array.</li> The table array contains a formula that has not been calculated.</li></ul> </li> Consider the following scenario. You try to save a workbook that contains a Microsoft Visual Basic for Applications project in Excel 2003. This workbook was opened from a mapped drive location. In this scenario, the workbook is not saved. Additionally, you receive the following error message:

Document cannot be saved.

If you try to save the workbook to a local location after you receive the error message, the workbook cannot be saved.</li> Consider the following scenario. You copy a cell in Excel 2003. This cell is contained on a worksheet that also contains a comment to a new workbook. The comment is also copied to this new workbook. In this scenario, Excel 2003 unexpectedly quits when you perform the following actions:  Rest the mouse on the comment in the new workbook.</li> Click the cell that contains the comment.</li></ul>

Additionally, you receive the following error message:

Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.

When you view the data in the error report, the report contains an error signature that is similar to the following error signature: </li> If you type a formula that contains the Choose function, Excel 2003 may unexpectedly quit. Additionally, you receive the following error message:

Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.

When you view the data in the error report, the report contains an error signature that is similar to the following error signature:

This issue may occur if the formula for the Choose function contains a space that follows the first comma in the formula. The following is an example of such a formula:

=Choose(1, 

</li> You use a PivotTable on a Microsoft Excel worksheet to filter data that is extracted from an Online Analytical Processing (OLAP) database. When you update the PivotTable, the filter criteria are lost. Additionally, you cannot reset the filter criteria.

</li> Consider the following scenario. You use the AutoComplete feature with the Input Method Editor 2000 (IME) in Excel 2003. Then, you run a Microsoft Visual Basic for Applications (VBA) macro.

In this scenario, you receive the following error message if the VBA macro does certain worksheet manipulations:

Run-time error '1004'

Examples of worksheet manipulations include moving data, copying data, or making the worksheet visible.

</li> You use a client program to extract data programmatically from an Excel worksheet. When you delay clicking to update the links in the Excel 2003 workbook, the Workbook_Open event in a Microsoft Visual Basic for Applications (VBA) macro may not run.

</li> If you programmatically copy and paste a whole row from a list of data in Excel 2003, the data is copied and pasted. However, you receive the following error message:

Run-time error '1004':

Copy method of range class failed.

This issue may occur if the following conditions are true: <ul> <li>The list of data is filtered</li> <li>There are hidden columns in the copy range.</li></ul> </li> <li>You open a worksheet in Excel 2003 by using a Microsoft Visual Basic for Applications (VBA) macro in Microsoft Office Word 2003. If the VBA macro uses the GetObject function to open the worksheet, you may experience one of the following symptoms: <ul> <li>When you scroll down and then up in the worksheet, incorrect data appears.</li> <li>The worksheet does not open, and Excel 2003 may unexpectedly quit. Additionally, you receive the following error message:

Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.

When you view the data in the error report, the report contains an error signature that is similar to the following error signature: </li></ul> </li></ul>

<div class="moreinformation_section">

Service pack information
This problem was first corrected in Office 2003 Service Pack 3.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. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

http://go.microsoft.com/?linkid=6294451

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Prerequisites
The following list contains prerequisites for the hotfix package: <ul> <li>The optimized version of this hotfix is a post-Microsoft Office 2003 Service Pack 2 hotfix. To install the hotfix, you must have Office 2003 Service Pack 2 installed. For more information about Office 2003 SP2, click the following article number to view the article in the Microsoft Knowledge Base:

887616 Description of Office 2003 Service Pack 2

</li> <li>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 Service Pack 2 installed or Microsoft Office 2003 with Service Pack 1 installed. However, we have tested this hotfix more extensively on Office 2003 with Service Pack 2 than we have on Microsoft Office 2003 with Service Pack 1. If you install this hotfix on a computer that is running Microsoft Office 2003 with Service Pack 1, some file conflicts might occur. We support this configuration, but we do not recommend this configuration.</li></ul>

Restart information
You do not have to restart your computer after you apply this hotfix.

Hotfix replacement information
This hotfix is not replaced by any later hotfix.

Registry information
You must create a registry key or modify a registry key to use one of the hotfixes that this package contains. For more information about the registry keys, click the following article numbers to view the articles in the Microsoft Knowledge Base:

887964 The LINEST function returns an incorrect value in Excel 2003

906679When you use the &quot;Open and Repair&quot; option to repair a worksheet, the DDE links are removed from the worksheet in Excel 2003

Hotfix file information
This hotfix may not contain all the files that you must have to fully update a product to the latest build. This hotfix contains only the files that you must have to correct the issues that this article lists.

The global version of this hotfix uses a Microsoft Windows Installer package to install the hotfix. The dates and times for these files are listed in coordinated universal time (UTC) in the following table. When you view the file information, the date 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

Microsoft Windows Installer .msp file information

After the hotfix package is installed, the global version of this hotfix package has the file attributes, or later file attributes, that are listed in the following table.

Additional notes: <ul> <li>For more information about how to install this hotfix, see the Readme.txt file that is included in the hotfix package.</li> <li>For more information about the differences between the two .msp files, see the &quot;Strategies for Updating Office 2003 Installations&quot; topic. To see this topic, visit the following Microsoft Web site:

http://office.microsoft.com/en-us/ork2003/HA011525741033.aspx

</li></ul>

For more information about the terminology that Microsoft uses when Microsoft corrects 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 product updates, tools, and add-ons

Additional query words: excel2003 excel2k3 xl2003 xl2k3

Keywords: kberrmsg kbfix kbqfe kbhotfixrollup kbexpertiseinter kbhotfixserver kboffice2003presp3fix kboffice2003sp3fix KB903240

-

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

© Microsoft Corporation. All rights reserved.