Microsoft KB Archive/323548

= Description of the Excel 2002 update: June 19, 2002 =

Article ID: 323548

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q323548



SUMMARY
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 &quot;More Information&quot; 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:

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



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

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

Click here to download the Client Update
 * 1) Click Download Now. Click Save this program to disk, and then click OK.
 * 2) Click Save to save the Exc1002.exe file to the selected folder.
 * 3) In Windows Explorer, double-click Exc1002.exe.
 * 4) If you are prompted to install the update, click Yes.
 * 5) Click Yes to accept the License Agreement.
 * 6) Insert your Office XP CD-ROM when you are 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 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.

http://office.microsoft.com/downloads/2002/exc1002.aspx

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

Click here to download the Administrative Update
 * 1) Download the file to your desktop.
 * 2) In Windows Explorer, double-click the Exc1002a.exe file.
 * 3) Click Yes to accept the License Agreement.
 * 4) In the Please type the location where you want to place the extracted files box, type C:\exc1002a, and then click OK.
 * 5) Click Yes when you are prompted to create the folder.
 * 6) 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]
 * 1) 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.

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

http://www.microsoft.com/office/ork/xp/journ/exc1002a.htm

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 &quot;read&quot;. 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 &quot;June&quot;, but the user selected &quot;May&quot;, the value &quot;June&quot; appears in the combo box after some Excel actions. The value in the property list, and the value in Visual Basic for Applications, is &quot;May&quot;.

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 &quot;-2147417848&quot; 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).

Additional query words: inf OFFXP fix list

Keywords: kbupdate kbservicepack kbhowto kbinfo kbofficexpsp2fix KB323548

-

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

© Microsoft Corporation. All rights reserved.