Microsoft KB Archive/329750

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

Article ID: 329750

Article Last Modified on 3/9/2007

-

APPLIES TO


 * Microsoft Excel 2002 Service Pack 2

-



This article was previously published under Q329750



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

307841 How to obtain the latest Office XP Service Pack



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 &quot;Windows Installer 2.0 Update Requirements&quot; 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:

325671 OFFXP: Overview of the Office XP Service Pack 2

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:

http://office.microsoft.com/ProductUpdates/default.aspx

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:  Visit the following Microsoft Web site:

Click here to download the Client Update

 Click Save to save the Exc1003.exe file to the selected folder. In Windows Explorer, double-click exc1003.exe. Click Yes if you receive the prompt to install the update.</li> Click Yes to accept the License Agreement.</li> Insert your Office CD-ROM if prompted to do so, and then click OK.</li> When you receive a message that indicates the installation was successful, click OK.</li></ol>

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.

http://www.microsoft.com/downloads/details.aspx?FamilyID=09708964-A8D6-4F4E-9D82-280E08F36E8A&displaylang=EN

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:

307841 OFFXP: How to Obtain the Latest Office XP Service Pack

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: <ol> Visit the following Microsoft Web site:

Click here to download the Administrative Update

</li> Download the file to your desktop.</li> In Windows Explorer, double-click exc1003a.exe.</li> Click Yes to accept the License Agreement.</li> In the Please type the location where you want to place the extracted files box, type C:\exc1003a, and then click OK.</li> Click Yes when you are prompted to create the folder.</li> 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 \  /p C:\ \  SHORTFILENAMES=TRUE

where  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).</li> To deploy the update, on the client workstations click Start, click Run, and then type the following command in the Open box

msiexec /i \  REINSTALL=EXCELFiles REINSTALLMODE=vomu

where  is the path to your administrative installation point (for example, C:\OfficeXP), and

where  is the MSI database package (for example, ProPlus.msi).

NOTE: To reinstall all Microsoft Office XP components on the client computer, use REINSTALL=ALL.</li></ol>

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:

301348 OFFXP: How to Install a Public Update to an Administrative Installation

This article contains standard instructions for installing an administrative public update.

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

http://www.microsoft.com/office/ork/xp/default.htm

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:

291331 HOW TO: Check the Version of Office XP

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:

This update has already been applied or is included in an update that has already been applied.

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:

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 Update
The Excel SP-2 2002 Update: October 16, 2002 fixes the issues described in the following Microsoft Knowledge Base articles.

324051 XL2002: The CPU Usage Is 100 Percent When You Copy a Large Sheet in Excel

320516 XL2002: You Cannot Open Excel Files in Windows Explorer After You Use the Text Import Wizard

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:

330008 MS02-059: Flaw in Word Fields and Excel External Updates May Lead to Information Disclosure

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.

Additional query words: inf OFFXP fix list

Keywords: kbdownload kbinfo KB329750

-

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

© Microsoft Corporation. All rights reserved.