Article ID: 324126 - View products that this article applies to.
This article was previously published under Q324126
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:
(http://support.microsoft.com/kb/276367/ )OFF2000: How to obtain the latest Office 2000 service pack
How to Download and Install the Update
Administrative UpdateIf 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:
304165This article contains standard instructions for installing an administrative public update.
(http://support.microsoft.com/kb/304165/ )How to download and install an update to an administrative installation of Office 2000
Alternatively, see the following article in the Microsoft Office XP Resource Kit:
How to Determine Whether the Public Update Is InstalledThe 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:
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 issues described in the following Knowledge Base articles:
(http://support.microsoft.com/kb/305694/ )XL2000: ALT+TAB Does Not Trigger Workbook_WindowActivate Event
(http://support.microsoft.com/kb/289629/ )XL2000: "An Unexpected Error Has Occurred" When You Update Links from Web Browser
(http://support.microsoft.com/kb/316479/ )XL2000: Contents of PivotTable Disappear When Data Is Updated in a Different Language Version of Excel
(http://support.microsoft.com/kb/272189/ )XL2000: JPN: Nested Group Objects in Excel 95 Workbook Are Displayed in Different Location
(http://support.microsoft.com/kb/278679/ )OFF2000: "This Workbook (Document) Has Been Password Protected" When You Open Workbook or Document
(http://support.microsoft.com/kb/300523/ )PPT2000: Embedded Excel Worksheets Shrink When You Edit Them
(http://support.microsoft.com/kb/304442/ )FIX: Excel 2000 May Fault in MSO9.DLL When Calling an XLL Function that Takes an Array
(http://support.microsoft.com/kb/303809/ )XL2000: Drawing Objects on Charts Move After You Save and Reopen
(http://support.microsoft.com/kb/305949/ )XL2000: CPU Usage Spikes at 100 Percent When Excel Is Running in the Background
(http://support.microsoft.com/kb/297883/ )XL2000: You Can See Other Users' Printers in a Terminal Server Session
(http://support.microsoft.com/kb/307809/ )XL: Excel Stops Responding When You Drag an Item in the PivotTable Layout Wizard
(http://support.microsoft.com/kb/311749/ )XL2000: Combo Box Control on a Worksheet Returns to Its Original Value After Refresh
(http://support.microsoft.com/kb/307609/ )XL2000: Borders of AutoShape on Embedded Excel Chart Change Thickness When Printed
(http://support.microsoft.com/kb/291110/ )XL2000: Cannot Use Keyboard Shortcuts to Select Ranges in RefEdit Control
(http://support.microsoft.com/kb/316399/ )XL2000: Error Message: No RETURN() or HALT() Function Found on Macro Sheet
(http://support.microsoft.com/kb/316070/ )PPT: Borders Are Lost When You Print Inserted Excel Objects at Printer Resolution
(http://support.microsoft.com/kb/318063/ )XL2000: Cannot Set the Orientation Property of a Pivot Field
(http://support.microsoft.com/kb/317850/ )XL2000: Excel Stops Responding When You Run VBA Macro Code That Displays a User Form
320520Additionally, the following issues have been fixed in this update but were previously not documented in the Microsoft Knowledge Base.
(http://support.microsoft.com/kb/320520/ )XL2000: Excel Quits Unexpectedly When You Switch Between Tab Strip and Chart on Worksheet
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.