Article ID: 324126 - Last Review: October 6, 2004 - Revision: 5.6 Description of the Excel 2000 SR-1 update: June 19, 2002This article was previously published under Q324126 On This PageSUMMARY 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
(http://support.microsoft.com/kb/276367/
)
OFF2000: How to obtain the latest Office 2000 service pack
MORE INFORMATIONHow to Download and Install the UpdateClient UpdateIf you installed Microsoft Excel 2000 from a CD-ROM, follow these steps:
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:
304165
(http://support.microsoft.com/kb/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
(http://www.microsoft.com/office/ork/xp/journ/exc0901a.htm)
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:305694
(http://support.microsoft.com/kb/305694/
)
XL2000: ALT+TAB Does Not Trigger Workbook_WindowActivate Event
289629
(http://support.microsoft.com/kb/289629/
)
XL2000: "An Unexpected Error Has Occurred" When You Update Links from Web Browser
316479
(http://support.microsoft.com/kb/316479/
)
XL2000: Contents of PivotTable Disappear When Data Is Updated in a Different Language Version of Excel
272189
(http://support.microsoft.com/kb/272189/
)
XL2000: JPN: Nested Group Objects in Excel 95 Workbook Are Displayed in Different Location
278679
(http://support.microsoft.com/kb/278679/
)
OFF2000: "This Workbook (Document) Has Been Password Protected" When You Open Workbook or Document
300523
(http://support.microsoft.com/kb/300523/
)
PPT2000: Embedded Excel Worksheets Shrink When You Edit Them
304442
(http://support.microsoft.com/kb/304442/
)
FIX: Excel 2000 May Fault in MSO9.DLL When Calling an XLL Function that Takes an Array
303809
(http://support.microsoft.com/kb/303809/
)
XL2000: Drawing Objects on Charts Move After You Save and Reopen
305949
(http://support.microsoft.com/kb/305949/
)
XL2000: CPU Usage Spikes at 100 Percent When Excel Is Running in the Background
297883
(http://support.microsoft.com/kb/297883/
)
XL2000: You Can See Other Users' Printers in a Terminal Server Session
307809
(http://support.microsoft.com/kb/307809/
)
XL: Excel Stops Responding When You Drag an Item in the PivotTable Layout Wizard
311749
(http://support.microsoft.com/kb/311749/
)
XL2000: Combo Box Control on a Worksheet Returns to Its Original Value After Refresh
307609
(http://support.microsoft.com/kb/307609/
)
XL2000: Borders of AutoShape on Embedded Excel Chart Change Thickness When Printed
291110
(http://support.microsoft.com/kb/291110/
)
XL2000: Cannot Use Keyboard Shortcuts to Select Ranges in RefEdit Control
316399
(http://support.microsoft.com/kb/316399/
)
XL2000: Error Message: No RETURN() or HALT() Function Found on Macro Sheet
316070
(http://support.microsoft.com/kb/316070/
)
PPT: Borders Are Lost When You Print Inserted Excel Objects at Printer Resolution
318063
(http://support.microsoft.com/kb/318063/
)
XL2000: Cannot Set the Orientation Property of a Pivot Field
317850
(http://support.microsoft.com/kb/317850/
)
XL2000: Excel Stops Responding When You Run VBA Macro Code That Displays a User Form
320520
(http://support.microsoft.com/kb/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". 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.
| Article Translations
|
Back to the top
