XL2002: Overview of Excel 2002 SP-2 Update: October 16, 2002

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:

How to Download and Install the Update

IMPORTANT: 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 Update

IMPORTANT: 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: If you installed Excel from a CD-ROM, you have the following two options:

• Use the Office Product Updates Web site to automatically install all of the latest updates that includes all available service packs and public updates.
  -or-
• Install only the Excel 2002 Update, by following the steps described later in this article.

NOTE: Microsoft recommends that you install the client update by using the Office Product Updates Web site. The Office Product Updates Web site detects your particular installation of Microsoft Office and prompts you to install exactly what you need to make sure that your Office installation is completely up-to-date.

Office Product Updates Web Site

To have the Office Product Updates Web site detect the required updates that you must install on your computer, visit the following Microsoft Web site: After 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, 2002

Follow these steps to download and install the client update:

1. Visit the following Microsoft Web site:
   Click here to download the Client Update (http://download.microsoft.com/download/excel2002/patch/exc1003/w98nt42kmexp/en-us/exc1003.exe)
2. Click Save to save the Exc1003.exe file to the selected folder.
3. In Windows Explorer, double-click exc1003.exe.
4. Click Yes if you receive the prompt to install the update.
5. Click Yes to accept the License Agreement.
6. Insert your Office CD-ROM if prompted to do so, and then click OK.
7. When you receive a message that indicates the installation was successful, click OK.

NOTE: After you install the Excel 2002 SP-2 Update: October 16, 2002, you cannot remove it.

For more information about the client update, click the link below for the Office Tools on the Web article.

Administrative Update

NOTE: 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: If 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.

If you are the server administrator, follow these steps to download the administrative update:

1. Visit the following Microsoft Web site:
   Click here to download the Administrative Update (http://download.microsoft.com/download/excel2002/patch/exc1003/w98nt42kmexp/en-us/exc1003a.exe)
2. Download the file to your desktop.
3. In Windows Explorer, double-click exc1003a.exe.
4. Click Yes to accept the License Agreement.
5. In the Please type the location where you want to place the extracted files box, type C:\exc1003a, and then click OK.
6. Click Yes when you are prompted to create the folder.
7. If you are familiar with the procedure for updating your administrative installation, click Start, click Run, and then type the following command in the Open box
   msiexec /a Admin Path\MSI File /p C:\exc1003a\MSP File SHORTFILENAMES=TRUE
   where Admin Path is the path to your administrative installation point (for example, C:\Excel2002),
   
   where MSI File is the .msi database package (for example, ProPlus.msi), and
   
   where MSP File is the name of the public administrative installation update (for example, EXCELff.msp).
8. To deploy the update, on the client workstations click Start, click Run, and then type the following command in the Open box
   msiexec /i admin path\MSI file REINSTALL=EXCELFiles REINSTALLMODE=vomu
   where admin path is the path to your administrative installation point (for example, C:\OfficeXP), and
   
   where MSI file is the MSI database package (for example, ProPlus.msi).
   
   NOTE: To reinstall all Microsoft Office XP components on the client computer, use REINSTALL=ALL.

For additional information about how to update your administrative installation and deploy to client workstations, click the article number below to view the article in the Microsoft Knowledge Base: This article contains standard instructions for installing an administrative public update.

Or, see the following article in the Microsoft Office XP Resource Kit:

How to Determine Whether the Update Is Installed

The 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: NOTE: 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:

Windows Installer 2.0 Update Requirements

The 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:

Issues Fixed by the Update

The Excel SP-2 2002 Update: October 16, 2002 fixes the issues described in the following Microsoft Knowledge Base articles. The update fixes the following issues that were previously not documented in the Microsoft Knowledge Base.

Security: Users Are Not Notified When a Maliciously Formed Workbook Contains Links to External Data

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.

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:

XL2002: The 'GetPivotData' Function Quits Unexpectedly

If 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 Responding

After 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 Functions

If 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 Tab

The 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 Opened

Your Excel workbook may close immediately after you open it if all the following conditions are true:

• The workbook contains one or more links that cannot be updated.
• The workbook contains an Auto_Open or an Workbook_Open macro.
• You choose to update the links and run macros (or have macros turned on [enabled] by default).

XL2002: Hyperlink Syntax Saved Incorrectly When You Save an Excel File As HTML

If 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 Cells

When 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 Open

When you open an Excel file with an OLE program, the OLE program closed, but the Excel process remains open.