Article ID: 326667 - View products that this article applies to.
This article was previously published under Q326667
Microsoft has released Office 2000 Service Pack 3 (SP-3). This article describes the issues that are fixed in Excel 2000 by this service pack.
For more information about how to download and install Office 2000 Service Pack (SP-3), click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/326585/ )Description of the Office 2000 Service Pack 3
Excel 2000 Issues Fixed by Office 2000 SP-3This service pack fixes the issues that are described in the following Microsoft Knowledge Base articles:
(http://support.microsoft.com/kb/276257/ )List of issues fixed in Office 2000 Service Pack 2
(http://support.microsoft.com/kb/306604/ )Description of the Excel 2000 SR-1 Macro Modification security update: April 25, 2002
(http://support.microsoft.com/kb/324126/ )Description of the Excel 2000 SR-1 update: June 19, 2002
(http://support.microsoft.com/kb/248207/ )Linked files with Lookup functions updated much more slowly than in earlier versions of Excel
(http://support.microsoft.com/kb/268079/ )OLAP data in Excel PivotTable is incorrect
(http://support.microsoft.com/kb/272189/ )Nested group objects in Excel 95 workbook are displayed in different location
(http://support.microsoft.com/kb/279248/ )VBA macro causes run-time error 1004 if AutoComplete uses IME
(http://support.microsoft.com/kb/279673/ )Excel quits unexpectedly if you delete data in cell
(http://support.microsoft.com/kb/280825/ )Excel quits unexpectedly when you use WorkbookBeforePrint event
(http://support.microsoft.com/kb/283090/ )Zoomed cells are not displayed correctly if you freeze panes on outline group
(http://support.microsoft.com/kb/283838/ )Cannot expand PivotTable if data is not saved with table
(http://support.microsoft.com/kb/290570/ )Embedded charts that contain text boxes in Excel 2000 do not behave as expected after they are edited in PowerPoint 2000 and in PowerPoint 2002
(http://support.microsoft.com/kb/276603/ )Excel quits unexpectedly when you use Replace command with long formulas or strings
(http://support.microsoft.com/kb/289629/ )"An unexpected error has occurred" when you update links from Web browser
(http://support.microsoft.com/kb/303809/ )Drawing objects on charts move after you save and reopen
(http://support.microsoft.com/kb/304442/ )Excel 2000 may fault in MSO9.DLL when calling an XLL function that takes an array
(http://support.microsoft.com/kb/305694/ )ALT+TAB does not trigger Workbook_WindowActivate event
(http://support.microsoft.com/kb/278679/ )"This workbook (document) has been password protected" when you open workbook or document
(http://support.microsoft.com/kb/305949/ )CPU usage spikes at 100 percent when Excel is running in the background
(http://support.microsoft.com/kb/297883/ )You can see other users' printers in a terminal server session
(http://support.microsoft.com/kb/307609/ )Borders of AutoShape on embedded Excel chart change thickness when printed
(http://support.microsoft.com/kb/307809/ )Excel stops responding when you drag an item in the PivotTable Layout Wizard
(http://support.microsoft.com/kb/309671/ )SR-1 stops responding when you open a file after an incomplete save
(http://support.microsoft.com/kb/291110/ )Cannot use keyboard shortcuts to select ranges in RefEdit control
(http://support.microsoft.com/kb/311749/ )Combo box control on a worksheet returns to its original value after refresh
(http://support.microsoft.com/kb/316399/ )Error message: No RETURN() or HALT() function found on macro sheet
(http://support.microsoft.com/kb/316479/ )Contents of PivotTable disappear when data is updated in a different language version of Excel
(http://support.microsoft.com/kb/317782/ )"Error -2147417848" occurs when data fields are added to a PivotTable from VBA
(http://support.microsoft.com/kb/317850/ )Excel stops responding when you run VBA macro code that displays a user form
(http://support.microsoft.com/kb/318063/ )Cannot set the Orientation property of a pivot field
(http://support.microsoft.com/kb/320520/ )Excel quits unexpectedly when you switch between tab strip and chart on worksheet
(http://support.microsoft.com/kb/321244/ )Drawings in files that are created in versions of Excel before Excel 97 are not displayed correctly
(http://support.microsoft.com/kb/323785/ )Processor spikes at 100 percent when you click AutoFilter arrow
(http://support.microsoft.com/kb/324312/ )You cannot reopen a file after you save it
(http://support.microsoft.com/kb/320262/ )VBA error on macro startup if you open multiple Excel instances with RefEdit control
(http://support.microsoft.com/kb/324391/ )Excel quits when GetPivotData function is in second workbook
(http://support.microsoft.com/kb/300629/ )Error message when you open an Excel workbook that has a URL that is no longer than 255 characters: "<File name> is locked for editing"
Additional Issues That Are Fixed by Office 2000 SP-3The issues in this section are also fixed by Office 2000 SP-3.
Security Update: Embedded Macro in Object May Bypass High Security SettingsA malicious user can insert a short macro command to an object or command bar button. The command then runs without warning when you click the object.
The Eurotool Add-in Does Not Support the Greek DrachmaThe Eurotool add-in does not contain support for the Greek Drachma.
Cannot Access Help for the EuroConvert() FunctionWhen you select Help in the Excel Function Wizard, the EuroConvert () function does not provide assistance as expected.
The WebChart Control May Cause a Buffer Overrrun If You Use Bad XMLThe WebChart control may cause a buffer overrun when bad XML is used.
Excel Stops Responding When the Username Is Greater Than 10 CharactersExcel may stop responding while switching between worksheets when username is greater than 10 characters.
You May Receive a Macro Error When You Run a Microsoft Visual Basic for Applications (VBA) script for a PivotTable OperationYou may receive a macro error when you run a VBA Script that creates and formats a series of PivotTables.
Contact us for more help
Connect with Answer Desk for expert help.