How to Download and Install the 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:
- 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]
- 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:
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:
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:
- Search for Excel.exe
- Right-click the Excel.exe file, and then click Properties on the shortcut menu.
- View the Version tab to determine the version of Excel that is on your computer.
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:
XL2000: ALT+TAB Does Not Trigger Workbook_WindowActivate Event
XL2000: "An Unexpected Error Has Occurred" When You Update Links from Web Browser
XL2000: Contents of PivotTable Disappear When Data Is Updated in a Different Language Version of Excel
XL2000: JPN: Nested Group Objects in Excel 95 Workbook Are Displayed in Different Location
OFF2000: "This Workbook (Document) Has Been Password Protected" When You Open Workbook or Document
PPT2000: Embedded Excel Worksheets Shrink When You Edit Them
FIX: Excel 2000 May Fault in MSO9.DLL When Calling an XLL Function that Takes an Array
XL2000: Drawing Objects on Charts Move After You Save and Reopen
XL2000: CPU Usage Spikes at 100 Percent When Excel Is Running in the Background
XL2000: You Can See Other Users' Printers in a Terminal Server Session
XL: Excel Stops Responding When You Drag an Item in the PivotTable Layout Wizard
XL2000: Combo Box Control on a Worksheet Returns to Its Original Value After Refresh
XL2000: Borders of AutoShape on Embedded Excel Chart Change Thickness When Printed
XL2000: Cannot Use Keyboard Shortcuts to Select Ranges in RefEdit Control
XL2000: Error Message: No RETURN() or HALT() Function Found on Macro Sheet
PPT: Borders Are Lost When You Print Inserted Excel Objects at Printer Resolution
XL2000: Cannot Set the Orientation Property of a Pivot Field
XL2000: Excel Stops Responding When You Run VBA Macro Code That Displays a User Form
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".
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".
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:
File name is locked for editing by 'user name'.
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 "Orientation' of object "PivotField" 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.