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.
: 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:
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.
- Install only the Excel 2002 Update, by following the steps described later in this article.
: 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:
- Visit the following Microsoft Web site:
- 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.
- Click Yes to accept the License Agreement.
- Insert your Office CD-ROM if prompted to do so, and then click OK.
- When you receive a message that indicates the installation was successful, click OK.
: After you install the Excel 2002 SP-2 Update: October 16, 2002, you cannot remove it.
: 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:
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 theadministrative update:
- Visit the following Microsoft Web site:
- Download the file to your desktop.
- In Windows Explorer, double-click exc1003a.exe.
- Click Yes to accept the License Agreement.
- In the Please type the location where you want to place the extracted files box, type C:\exc1003a, and then click OK.
- Click Yes when you are prompted to create the folder.
- 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).
- 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=vomuwhere 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:
OFFXP: How to Install a Public Update to an Administrative Installation
This article contains standard instructions for installing an administrative public update.
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:
HOW TO: Check the Version of Office XP
: 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:
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.
XL2002: The CPU Usage Is 100 Percent When You Copy a Large Sheet in Excel
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
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:
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
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.