How to Download and Install the Update
Client Update
If you installed Office XP from a CD-ROM, you have 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 Public Update
by using the steps described later.
Both options require that you have your Office XP CD-ROM
available throughout the installation process.
Office Product Updates
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 Excel 2002 Update
This update requires that Microsoft Office XP Service Pack 1
(SP-1) be installed.
For
additional information about obtaining and installing Microsoft Office XP
Service Pack 1 (SP-1), click the article number below to view the article in
the Microsoft Knowledge Base:
307843 OFFXP: Overview of the Office XP Service Pack 1
Follow these steps to download and
install the client update:
- Visit the following Microsoft Web site:
Click
here to download the Client Update - Click Download Now. Click Save this program to disk, and then click
OK.
- Click Save to save the Exc1002.exe file to the selected folder.
- In Windows Explorer, double-click Exc1002.exe.
- If you are prompted to install the update, click Yes.
- Click Yes to accept the License Agreement.
- Insert your Office XP CD-ROM when you are prompted to do
so, and then click OK.
- When you receive a message that indicates the installation
was successful, click OK.
NOTE: After you install the public update, you cannot remove
it.
For more information about the Client Patch, click the link below
for the Office Tools on the Web article.
Administrative Update
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:
- Visit the following Microsoft Web site:
Click
here to download the Administrative Update - Download the file to your desktop.
- In Windows Explorer, double-click the Exc1002a.exe file.
- Click Yes to accept the License Agreement.
- In the Please type the location where you want to
place the extracted files box, type
C:\exc1002a, and then click OK.
- Click Yes when you are prompted to create the folder.
- Click Start and then click Run. Type the following command in the Open box:
[start] msiexec /p [path\name of update
MSP file] /a [path\name of MSI file] SHORTFILENAMES=TRUE /qb /L*v [path\name of
log file] - To deploy the update to the client workstations, click Start and then click Run. Type the following command in the Open box:
[start] msiexec /i [path to updated .msi
file on the administrative image] REINSTALL=EXCELFiles REINSTALLMODE=vomus
/q
For additional
information about how to update your administrative installation and deploy to
client workstations, click the following article number to view the article in
the Microsoft Knowledge Base:
301348
How to install a public update to administrative installations of Office XP
This article contains standard instructions for installing an
administrative public update.\
�
How to Determine Whether the Public Update Is Installed
Excel 2002 Update: June 19, 2002 affects the Excel.exe file.
Excel 2002 Update: June 19, 2002 updates the version of Microsoft Excel 2002 to
version 10.0.4109.0. In Excel, click
About Microsoft Excel on the
Help menu to determine the version that is on your computer.
NOTE: If Excel 2002 Update: June 19, 2002 is already applied to your
computer, you receive the following message when you try to install Excel 2002
Update: June 19, 2002:
This update has already been applied or is included in an update that has already been applied.
Issues Fixed by the Update
The update fixes the following issues that were previously not
documented in the Microsoft Knowledge Base.
XL2002: Security Update: Excel Macro Security Bypassed Through Hyperlink
If a hyperlink that ends with an exclamation point is
placed on a shape and points to another Excel file, when you click or edit the
hyperlink, the target Excel file opens and runs the macro without any macro
security warning.
WD2002: Security Update: File Marked As 'Not Clean' Is Still Opened by Word
If your antivirus software finds a file that is
infected with a macro virus but it cannot clean the file, Word may still open
the file and run the macros in it, depending on the security settings set in
Word.
XL2002: Security Update: Replying to Apply a Style Sheet Allows Script to Be Run
When you open an XML file that contains an applied XSL
style sheet, if you click OK to apply the style sheet, Excel may allow a script in the XSL
file to be run without warning.
XL2002: Security Update: Malicious Macro Inserting Text Causes Excel to Quit
A malicious macro can insert too much text into an
Excel workbook. You receive an error message, and then Excel quits.
XL2002: Security Update: Embedded Macro in Object May Bypass High Security Settings
A malicious user can insert a short macro command to an
object or command bar button; the command runs without warning when you click
the object.
XL2002: Computer Stops Responding While You Are Locating a File That Is Open in Excel 2002 If you have a file open in Excel, and then you try
locate that file in Internet Explorer (version 5.5 or later), you may receive
the following error message:
The instruction at [memory
address] references memory at [memory address]. The memory could not be "read".
Click Ok to terminate the program.
XL2002: Visual Basic for Applications Flip Method Does Not Correctly Change the Vertical or Horizontal Position of an Embedded Image
Certain images that are created in an Office 97
document and opened in either Office 2000 or Office XP display the images
flipped and inverted.
XL2002: Users See Other Users Printers in Terminal Server Sessions
When you use Microsoft Excel 2002 in a Terminal Server
session and try to print, Excel shows all the printers for all of the active
Terminal Server sessions.
XL2002: Digital Signature Lost When Excel Does an AutoSave
A digital signature is lost when the AutoRecovery
option is turned ON and an AutoSave occurs.
XL2002: Japanese Excel Quits Unexpectedly When You Drag an Item
When you drag an item into the PivotTable Wizard Layout dialog box, Excel may quit unexpectedly.
XL2002: AutoShape Borders of Embedded Excel Chart Appear Thinner When Printed
When you use the Square drawing tool on a chart, the
border may print differently in Excel and Word.
XL2002: Controls Show Wrong Value When Opening Workbook with a Hyperlink
A Combo box control on a worksheet may display the
original values, instead of new values, after events occur that cause the
display to be refreshed. For example, if a combo box is initialized with the
value "June", but the user selected "May", the value "June" appears in the
combo box after some Excel actions. The value in the property list, and the
value in Visual Basic for Applications, is "May".
XL2002: Cannot Use Keyboard Shortcuts to Select RefEdit Ranges
You cannot use a keyboard shortcut to select RefEdit
ranges.
XL2002: DDE Channel Closed When Open or Save As Dialog Box Open
If a DDE channel is open and you open the Open dialog box (on the File menu, click Open) or the Save As dialog box (on the File menu, click Save As), an error is returned to the client when a DDE request is sent
and the DDE connection is closed.
XL2002: File with PivotTable Grows in File Size When Saved
Any file that contains a PivotTable will get larger
each time it is saved and closed, even if there are no changes to the data in
the file. This occurs whether you save the pivot data with the file or not, and
also whether or not the data is external to the Excel file.
XL2002: Disabling Macro Causes Excel to Quit
When you open an Excel workbook that contains an
AutoOpen macro, if you click No to not enable macros, Excel quits unexpectedly and there is a
"-2147417848" error.
XL2002: Recovered Encrypted File Causes Excel to Quit Unexpectedly
If you click Convert to values when you open a recovered file, Excel may quit unexpectedly.
XL2002: Long URL in IQY File May Causes Excel to Quit Unexpectedly
When you open a Microsoft Excel Web query file (.iqy)
that contains a long URL, Excel may quit unexpectedly.
XL2002: Excel Quits Unexpectedly When You Use FileDialog Object
If you use msoFileDialogSaveAs as an argument with the FileDialog object, Excel may quit
unexpectedly.
XL2002: Japanese Excel Quits Unexpectedly When Calculated Field Inserted
If you insert a Calculated Field that contains DBCS
characters by using the Insert Field button while Speech is enabled, Excel may quit unexpectedly and
may not recover the file or may not display an error message.
XL2002: Japanese Excel Quits Unexpectedly Using Input Method Editor (IME)
When you use the Input Method Editor (IME) in Japanese
Excel to input certain Japanese symbols, Excel may quit unexpectedly.
XL2002: Excel Quits During Refresh Condition
Excel may unexpectedly quit, and you may receive an
error message, when certain refresh conditions occur.
XL2002: Excel May Stop Unexpectedly When You Copy and Paste Cells Between Workbooks
When you copy a range of cells from one workbook to
another, if the style that is used in the source workbook is not available in
the target workbook, Excel may quit and you receive an error message.
XL2002: Switching Between Tab Strip and Chart on Worksheet Causes Excel to Quit
When you switch between a Chart and a Microsoft Forms
TabStrip control when you are working in cells on a worksheet, Excel may quit
unexpectedly.
XL2002: Cannot Activate Embedded Excel Object
This update corrects a problem from an earlier update.
In a document that contains an Excel embedded object, you may not be able to
activate the Excel object when an antivirus scanner is installed.
XL2002: Excel May Quit, You Receive Error Message When ToolTip Text Is Bold
After you apply a bold style to ToolTip text, you may
receive an error message, and Excel may quit when pause on text to show the
ToolTip.
XL2002: Localized Excel May Quit in Print Preview
When you use a localized Microsoft Windows operating
system and view an Excel file in print preview, you may receive an error
message and Excel may quit.
XL2002: Contents of PivotTable Disappear When Opened in Different Language Version of Excel
When you create a PivotTable based on multiple
consolidation ranges, open the file in a different language version of Excel,
and then refresh the data, the contents of the PivotTable disappear.
XL2002: Excel Quits Unexpectedly When You Make Changes to Chart
After you delete some data on a worksheet that is used
for a chart, Excel may quit unexpectedly when you make changes to the chart.
XL2002: Cannot Open .xls File in Explorer After Using Text Import Wizard
After you use the Text Import Wizard in Excel to open a
text file, you may not be able to open an Excel file when you double-click it
in Windows Explorer or in the Recent Documents list (click Start, and then point to Recent Documents).