Article ID: 329750
This article has been archived. It is offered "as is" and will no longer be updated.
This update permits the Ask to update automatic links option to override any attempts from a malicious user to suppress the warning dialog that appears in a Microsoft Excel workbook when a Microsoft Excel spreadsheet contains links to external data.
This article describes how to download and install the Excel 2002 SP-2 Update: October 16, 2002.
This update was first included in Office XP Service Pack 3. For additional information about the latest service pack for Office XP, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/307841/ )How to obtain the latest Office XP Service Pack
How to Download and Install the UpdateIMPORTANT: The installation of the update that is described in this article requires that your version of Microsoft Windows Installer be 2.0 or later. For additional information about this requirement, see the "Windows Installer 2.0 Update Requirements" section of this article.
Client UpdateIMPORTANT: Before you install the client update, you must have Microsoft Office XP Service Pack 2 (SP-2) installed. For additional information about how to install Office XP SP-2, click the article number below to view the article in the Microsoft Knowledge Base:
325671If you installed Excel from a CD-ROM, you have the following two options:
(https://support.microsoft.com/kb/325671/EN-US/ )OFFXP: Overview of the Office XP Service Pack 2
Office Product Updates Web SiteTo have the Office Product Updates Web site detect the required updates that you must install on your computer, visit the following Microsoft Web site:
http://office.microsoft.com/ProductUpdates/default.aspxAfter detection is complete, you receive a list of recommended updates for your approval. Click Start Installation to complete the process.
Install Only the Excel 2002 SP-2 Update: October 16, 2002Follow these steps to download and install the client update:
Administrative UpdateNOTE: Before you install the administrative update by using the steps in this article, verify that your administrative installation point has Microsoft Office XP Service Pack 1 (SP-1) or Office XP SP-2 installed. For additional information about how to obtain the latest Office XP Service Pack, click the article number below to view the article in the Microsoft Knowledge Base:
307841If you installed Microsoft Excel 2002 from a server location, the server administrator must update the server location with the administrative public update and deploy that update to your computer.
(https://support.microsoft.com/kb/307841/EN-US/ )OFFXP: How to Obtain the Latest Office XP Service Pack
If you are the server administrator, follow these steps to download the administrative update:
301348This article contains standard instructions for installing an administrative public update.
(https://support.microsoft.com/kb/301348/EN-US/ )OFFXP: How to Install a Public Update to an Administrative Installation
How to Determine Whether the Update Is InstalledThe Excel 2002 SP-2 Update: October 16, 2002 affects the Excel.exe file. The Excel 2002 SP-2 Update: October 16, 2002 updates the version of Excel 2002 that is installed on your computer to version 10.0.4524.0. In Excel, click About Microsoft Excel on the Help menu to determine the version that is on your computer.
For additional information about how to check the version of Office XP, click the article number below to view the article in the Microsoft Knowledge Base:
291331NOTE: If Excel 2002 SP-2 Update: October 16, 2002 is already installed on your computer, you receive the following message when you try to install Excel 2002 SP-2 Update: October 16, 2002:
(https://support.microsoft.com/kb/291331/EN-US/ )HOW TO: Check the Version of Office XP
This update has already been applied or is included in an update that has already been applied.
Windows Installer 2.0 Update RequirementsThe installation of the Excel 2002 SP-2 Update: October 16, 2002 requires that your version of Microsoft Windows Installer be 2.0 or later. Microsoft Windows 2000 Service Pack 3 (SP-3) and Microsoft Windows XP include this version of the Windows Installer. To install the latest version of the Windows Installer, visit one of the following Microsoft Web sites:
Windows Installer for Microsoft Windows 95, Microsoft Windows98, and Microsoft Windows Millennium Edition (Me)
Windows Installer for Windows NT 4.0 and 2000
Issues Fixed by the UpdateThe Excel SP-2 2002 Update: October 16, 2002 fixes the issues described in the following Microsoft Knowledge Base articles.
(https://support.microsoft.com/kb/324051/EN-US/ )XL2002: The CPU Usage Is 100 Percent When You Copy a Large Sheet in Excel
320516The update fixes the following issues that were previously not documented in the Microsoft Knowledge Base.
(https://support.microsoft.com/kb/320516/EN-US/ )XL2002: You Cannot Open Excel Files in Windows Explorer After You Use the Text Import Wizard
Security: Users Are Not Notified When a Maliciously Formed Workbook Contains Links to External DataThis update permits the Ask to update automatic links option to override any attempts from a malicious user to suppress the warning dialog that appears in a Microsoft Excel workbook when a Microsoft Excel spreadsheet contains links to external data.
IMPORTANT: If the Ask to update automatic links option in not turned on (enabled), you are still vulnerable to the security issue that is described in this article. To configure the Ask to update automatic links option in Excel, click Options on the Tools menu, and then click the Edit tab.
For additional information about this issue documented in the Microsoft Security Bulletin MS02-059, click the article number below to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/330008/EN-US/ )MS02-059: Flaw in Word Fields and Excel External Updates May Lead to Information Disclosure
XL2002: The 'GetPivotData' Function Quits UnexpectedlyIf you create a GetPivotData function, Excel may quit unexpectedly. This problem occurs if the PivotTable contains a date field and is in one workbook, and the GetPivotData function is in a different workbook.
XL2002: Shared Workbook May Cause Excel to Stop RespondingAfter you save a shared workbook, Excel may stop responding. You can resolve the issue for a short time by removing the custom views for each user, but the issue returns.
XL2002: The 'Field' List in a PivotTable No Longer FunctionsIf a PivotTable contains a lot of data, the Field list no longer functions after Excel performs a successful repair on the Excel workbook that contains the PivotTable.
XL2002: JPN: Excel Automatically Calculates Values Even If the Feature Is Turned Off On the Calculations TabThe Japanese version of Excel may automatically calculate values even if the feature is turned off on the Calculations tab.
XL2002: Excel Workbook Closes Immediately After It Is OpenedYour Excel workbook may close immediately after you open it if all the following conditions are true:
XL2002: Hyperlink Syntax Saved Incorrectly When You Save an Excel File As HTMLIf you open an Excel workbook with cross-sheet hyperlinks and save it as an HTML page, the hyperlink syntax is not saved correctly and the hyperlinks do not work when you open the HTML file in a Web browser.
XL2002: Excel Stops Responding When You Remove Subtotals from a Range of CellsWhen you try to remove subtotals from a range of cells in Excel, Excel may stop responding, and the CPU usage is 100 percent.
XL2002: When You Open an Excel File with an OLE Program, the OLE Program Closes but the Excel Process Remains OpenWhen you open an Excel file with an OLE program, the OLE program closed, but the Excel process remains open.