Microsoft KB Archive/324126

= Description of the Excel 2000 SR-1 update: June 19, 2002 =

Article ID: 324126

Article Last Modified on 10/6/2004

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q324126



SUMMARY
Microsoft has released an update to Microsoft Excel 2000. This update includes several security updates and other issues that are corrected.

This article describes how to download and install Excel 2000 Update: June 19, 2002.

Important Before you install Excel 2000 Update: June 19, 2002, Microsoft Office 2000 Service Release 1a (SR-1a) must already be installed on your computer.

For additional information about the latest service pack for Microsoft Office 2000, click the following article number to view the article in the Microsoft Knowledge Base:

276367 OFF2000: How to obtain the latest Office 2000 service pack



Client Update
If you installed Microsoft Excel 2000 from a CD-ROM, follow these steps:
 * 1) Visit the following Microsoft Web site:

http://office.microsoft.com/downloads/2000/exc0901.aspx
 * 1) Click Download Now. Click Save this program to disk, and then click OK.
 * 2) Click Save to save the Exc0901.exe file to the selected folder.
 * 3) In Windows Explorer, double-click Exc0901.exe.
 * 4) If you are prompted to install the update, click Yes.
 * 5) Click Yes to accept the License Agreement.
 * 6) Insert your Office 2000 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.

Administrative Update
If you installed Microsoft Excel 2000 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:  Visit the following Microsoft Web site:

http://download.microsoft.com/download/Excel2000/Patch/exc0901/W982KMeXP/EN-US/exc0901a.exe

 Download the file to your desktop. In Microsoft Windows Explorer, double-click the Exc0901a.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:\exc0901a, 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] </li> 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 </li></ol>

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:

304165 How to download and install an update to an administrative installation of Office 2000

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/exc0901a.htm

How to Determine Whether the Public Update Is Installed
The Excel 2000 Update: June 19, 2002 affects the Excel.exe file. Excel 2000 Update: June 19, 2002 updates the version of Microsoft Excel 2000 to version 9.0.6508. To determine the version of Microsoft Excel installed on your computer, follow these steps:
 * 1) Search for Excel.exe
 * 2) Right-click the Excel.exe file, and then click Properties on the shortcut menu.
 * 3) View the Version tab to determine the version of Excel that is on your computer.

Note If Excel 2000 Update: June 19, 2002 is already applied to your computer, you will receive the following message when you try to install the Excel 2000 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 issues described in the following Knowledge Base articles:

305694 XL2000: ALT+TAB Does Not Trigger Workbook_WindowActivate Event

289629 XL2000: &quot;An Unexpected Error Has Occurred&quot; When You Update Links from Web Browser

316479 XL2000: Contents of PivotTable Disappear When Data Is Updated in a Different Language Version of Excel

272189 XL2000: JPN: Nested Group Objects in Excel 95 Workbook Are Displayed in Different Location

278679 OFF2000: &quot;This Workbook (Document) Has Been Password Protected&quot; When You Open Workbook or Document

300523 PPT2000: Embedded Excel Worksheets Shrink When You Edit Them

304442 FIX: Excel 2000 May Fault in MSO9.DLL When Calling an XLL Function that Takes an Array

303809 XL2000: Drawing Objects on Charts Move After You Save and Reopen

305949 XL2000: CPU Usage Spikes at 100 Percent When Excel Is Running in the Background

297883 XL2000: You Can See Other Users' Printers in a Terminal Server Session

307809 XL: Excel Stops Responding When You Drag an Item in the PivotTable Layout Wizard

311749 XL2000: Combo Box Control on a Worksheet Returns to Its Original Value After Refresh

307609 XL2000: Borders of AutoShape on Embedded Excel Chart Change Thickness When Printed

291110 XL2000: Cannot Use Keyboard Shortcuts to Select Ranges in RefEdit Control

316399 XL2000: Error Message: No RETURN or HALT Function Found on Macro Sheet

316070 PPT: Borders Are Lost When You Print Inserted Excel Objects at Printer Resolution

318063 XL2000: Cannot Set the Orientation Property of a Pivot Field

317850 XL2000: Excel Stops Responding When You Run VBA Macro Code That Displays a User Form

320520 XL2000: Excel Quits Unexpectedly When You Switch Between Tab Strip and Chart on Worksheet

Additionally, the following issues have been fixed in this update but were previously not documented in the Microsoft Knowledge Base.

XL2000: Security Update: Change in Binary Format Can Bypass Macro Security

If a file is changed at the binary level, the file may bypass Excel macro security settings.

OFF2000: Security Update: Office Programs Do Not Warn When You Open Infected Documents That Have Been Flagged or Scanned by Antivirus Software.

When you open an Excel file that has been flagged by antivirus software as infected, Excel may not warn you that the file contains macros that may damage to your system.

XL2000: Security Update: Embedded Macro Command Object Can Bypass High Security Settings

When you click an embedded object, a macro that can bypass Excel security settings may be run.

OFF: 100% CPU Usage When You Hold Left Mouse Button Down

When you use any of the Office programs on a Microsoft Windows 2000-based computer, the CPU usage reaches 100% if you hold the left mouse button down for more then a few seconds.

XL2000: PivotTable Operation with a Macro Causes Error

In Microsoft Excel Version 2000, when you run a Visual Basic for Applications macro that creates and format a series of PivotTables several times, you may receive the error message:

Run-time error: -2147417848 (80010108) 'Position' method failed: 'PivotField' object&quot;.

XL2000: Transition Navigation Keys Setting Is Not Retained

When you use the Multilanguage Pack for Office 2000, the Transition navigation keys setting is lost when you quit Excel.

(To view the Transition navigation keys check box, click Options on the Tools menu, and then click the Transition tab.)

XL2000: When You Save File with Chart as Excel 5.0/95 Format, Excel Quits Unexpectedly

In Excel 2000, when you open an Excel 95 file that contains a chart, and then save the file in Excel 5.0/95 format, Excel may quit unexpectedly.

XL2000: Embedded Charts with Custom Colors Lose Colors When Saved As HTML

Embedded charts on a worksheet do not retain custom colors if you save the workbook as HTML and then open it in Microsoft Internet Explorer. If you open the same HTML file in Excel 2000, the custom colors are displayed as expected.

XL2000: Chart Resized After You Embed It in Word

If you set a chart to a custom size in Excel, copy the chart, and then embed it in a Word document, the chart in the original file may be resized to the Excel window.

XL2000: JPN: Macro Causes Error After Using AutoComplete

After you insert an AutoComplete entry, when you run a macro, you may receive the following error message:

Run-time error '1004': Method 'Visible' of object '_Worksheet' failed&quot;.

XL2000: Custom Chart Resized After Editing in Word

When you edit a custom size Excel chart in-place in Word, the chart may lose its custom size.

XL2000: JPN: Bad Redraw with Freeze Panes Used with Outline Group

After you group a series of cells, and then click Freeze Panes while you are working with a Zoom value of less than 100%, the freeze pane may move to the left and some column text may be deleted.

XL2000: Cannot Follow a Path to Further Analysis in PivotTable

In Excel 2000, you cannot follow a path to to further analysis in a PivotTable unless the Save data with table layout option is selected.

XL2000: JPN: Excel Quits Scrolling Mouse Horizontally

In print preview, when you try to scroll horizontally by using a touch pad, Excel may generate an application error, and then quit unexpectedly.

XL2000: JPN: Excel Quits Unexpectedly Inserting a Calculated Field

When you use Excel 2000 with a program that uses Windows Messaging, if you add a calculated field with a double-byte character set (DBCS) field name to a PivotTable, there may be an access violation in Excel.

XL2000: Error Message When User Name Is Longer Than Nine Characters

If you change your user name in Excel to a name that is more than nine characters long, and you then switch between multiple Excel worksheets, Excel stops responding (hangs) when you quit Excel.

XL2000: Error Message States That File Locked by Another User

When you open an Excel file with a URL longer than 255 characters, you may receive the following error message:

is locked for editing by ' '.

XL2000: Excel Quits Unexpectedly When You Save File That Contains Charts

If you try to save a workbook that contains charts in Microsoft Excel 2000 SR-1, Excel may stop responding or quit unexpectedly. After this problem occurs, Excel quits unexpectedly again when you try to reopen the workbook.

XL2000: Adding Data Fields to a Pivot Table From Macro Can Cause Error

If you use an Excel worksheet that contains a macro to create and format a series of PivotTables, you may receive the following error message:

Run-time error '-2147417848 (80010108)': Method &quot;Orientation' of object &quot;PivotField&quot; failed.

XL2000: Application Error When You Quit Excel on a SharePoint Portal Server Client

On a Microsoft SharePoint Portal Server Client, if you quit Excel after you open an .xls file that includes a Microsoft Outlook Express envelope, there may be an application error and Excel may quit.

XL2000: Radar Chart Shrinks After Print Preview

After you print preview a worksheet that contains a radar chart, the radar chart dimensions shrink dramatically.

Additional query words: inf OFFXP fix list

Keywords: kbinfo kboffice2000sp3fix kbupdate atdownload KB324126

-

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

© Microsoft Corporation. All rights reserved.