Article ID: 323548 - View products that this article applies to.
This article was previously published under Q323548
Microsoft has released an update to Microsoft Excel 2002. This update includes several security updates and other issues that are corrected in the update.
This article describes how to download and install the Excel 2002 Update: June 19, 2002.
NOTE: This Public Update is part of the Microsoft Office XP Service Pack 2 (SP-2), but for your convenience the Public Update also is available individually, as described in the "More Information" section of this article. If you already applied Office XP SP-2, you do not have to apply this Public Update. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/307841/EN-US/ )OFFXP: How to Obtain the Latest Office XP Service Pack
How to Download and Install the Update
Client UpdateIf you installed Office XP from a CD-ROM, you have two options:
Office Product UpdatesTo 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 Excel 2002 UpdateThis 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:
(http://support.microsoft.com/kb/307843/EN-US/ )OFFXP: Overview of the Office XP Service Pack 1
Follow these steps to download and install the client update:
For more information about the Client Patch, click the link below for the Office Tools on the Web article.
Administrative UpdateIf 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:
301348This article contains standard instructions for installing an administrative public update.\
(http://support.microsoft.com/kb/301348/ )How to install a public update to administrative installations of Office XP
How to Determine Whether the Public Update Is InstalledExcel 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 UpdateThe 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).