Description of Excel 2002 post-Service Pack 2 hotfix package: July 11, 2003

This article describes the Microsoft Excel 2002 issues that are fixed in the Microsoft Excel 2002 Post-Service Pack 2 Hotfix package that is dated July 11, 2003.

Issues That Are Fixed in the Hotfix Package

The following issues are fixed in this hotfix package. These issues were not previously documented in a Microsoft Knowledge Base article

• The ChangeLink Method Does Not Behave As Excepted
  
  Not all array formulas that contain external Microsoft Excel links are changed when you use the Microsoft Visual Basic for Applications (VBA) ChangeLink method.
• The Range.Calculate or the Selection.Calculate Methods Fail After You Update Links to a Dynamic Data Exchange (DDE) Server
  
  Excel does not calculate ranges in a workbook when the Range.Calculate or the Selection.Calculate methods are called. This issue occurs after you open and update any workbook with DDE links.

Service Pack Information

This problem was first corrected in Microsoft Office XP Service Pack 3. To resolve this problem, obtain the latest service pack for Microsoft Office XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

Hotfix Information

A supported hotfix is 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.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if 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. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

• The optimized version of this hotfix is a post-Office XP Service Pack 2 (SP-2) hotfix. To install the hotfix, you must have Office XP SP-2 installed.
  
  For additional information about Office XP SP-2, click the following article number to view the article in the Microsoft Knowledge Base:
  325671 OFFXP: Overview of the Office XP Service Pack 2
• The optimized version of this hotfix requires Microsoft Windows Installer 2.0 or later.
  
  For additional information about the Windows Installer requirement, click the following article number to view the article in the Microsoft Knowledge Base:
  330537 OFFXP: Office XP updates and patches released after September 2002 may require Windows Installer 2.0
• The full-file version of this hotfix is also the administrative version of this hotfix. You can install this version of the hotfix with Microsoft Office XP Service Pack 1 (SP-1). However, Microsoft has not tested this fix on Office XP SP-1 to the same extent as on Office XP Service Pack 2 (SP-2). If you install this hotfix on a computer with Office XP SP-1 installed, some file conflicts might occur. Microsoft supports this configuration, but we do not recommend this configuration.

Restart Information

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

Hotfix Replacement Information

This hotfix package is replaced by a later hotfix package.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

Registry Information

You do not have to create or modify any registry keys to activate any hotfixes that are contained in this hotfix package.

Hotfix File Information

This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix package may not contain all the package 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) 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. After the hotfix is installed, the global version of this fix has the file attributes (or later) that are listed in the following table:Note For more information about hoe to install this hotfix, see the Readme.txt file that is included in the package.

For additional 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: