Excel 2000 Issues Fixed by Office 2000 SP-3
This service pack fixes the issues that are described in the following Microsoft Knowledge Base articles:
List of issues fixed in Office 2000 Service Pack 2
Description of the Excel 2000 SR-1 Macro Modification security update: April 25, 2002
Description of the Excel 2000 SR-1 update: June 19, 2002
Linked files with Lookup functions updated much more slowly than in earlier versions of Excel
OLAP data in Excel PivotTable is incorrect
Nested group objects in Excel 95 workbook are displayed in different location
VBA macro causes run-time error 1004 if AutoComplete uses IME
Excel quits unexpectedly if you delete data in cell
Excel quits unexpectedly when you use WorkbookBeforePrint event
Zoomed cells are not displayed correctly if you freeze panes on outline group
Cannot expand PivotTable if data is not saved with table
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
Excel quits unexpectedly when you use Replace command with long formulas or strings
"An unexpected error has occurred" when you update links from Web browser
Drawing objects on charts move after you save and reopen
Excel 2000 may fault in MSO9.DLL when calling an XLL function that takes an array
ALT+TAB does not trigger Workbook_WindowActivate event
"This workbook (document) has been password protected" when you open workbook or document
CPU usage spikes at 100 percent when Excel is running in the background
You can see other users' printers in a terminal server session
Borders of AutoShape on embedded Excel chart change thickness when printed
Excel stops responding when you drag an item in the PivotTable Layout Wizard
SR-1 stops responding when you open a file after an incomplete save
Cannot use keyboard shortcuts to select ranges in RefEdit control
Combo box control on a worksheet returns to its original value after refresh
Error message: No RETURN() or HALT() function found on macro sheet
Contents of PivotTable disappear when data is updated in a different language version of Excel
"Error -2147417848" occurs when data fields are added to a PivotTable from VBA
Excel stops responding when you run VBA macro code that displays a user form
Cannot set the Orientation property of a pivot field
Excel quits unexpectedly when you switch between tab strip and chart on worksheet
Drawings in files that are created in versions of Excel before Excel 97 are not displayed correctly
Processor spikes at 100 percent when you click AutoFilter arrow
You cannot reopen a file after you save it
VBA error on macro startup if you open multiple Excel instances with RefEdit control
Excel quits when GetPivotData function is in second workbook
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-3
The issues in this section are also fixed by Office 2000 SP-3.
Security Update: Embedded Macro in Object May Bypass High Security Settings
A 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 Drachma
The Eurotool add-in does not contain support for the Greek Drachma.
Cannot Access Help for the EuroConvert() Function
When 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 XML
The WebChart control may cause a buffer overrun when bad XML is used.
Excel Stops Responding When the Username Is Greater Than 10 Characters
Excel 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 Operation
You may receive a macro error when you run a VBA Script that creates and formats a series of PivotTables.