SUMMARY
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:
326585
Description of the Office 2000 Service Pack 3
MORE INFORMATION
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:
276257 List of issues fixed in
Office 2000 Service Pack 2
306604 Description of the Excel 2000 SR-1 Macro Modification security update: April 25, 2002
324126 Description of the Excel 2000 SR-1
update: June 19, 2002
248207 Linked files with Lookup
functions updated much more slowly than in earlier versions of
Excel
268079 OLAP data in Excel PivotTable is incorrect
272189 Nested group objects in Excel 95 workbook are displayed in different
location
279248 VBA macro causes run-time error 1004 if AutoComplete uses IME
279673 Excel quits unexpectedly if you delete data in cell
280825 Excel quits unexpectedly when you use WorkbookBeforePrint event
283090 Zoomed cells are not displayed correctly if you freeze panes on outline group
283838 Cannot expand PivotTable if data is not saved with table
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
276603 Excel quits unexpectedly when you use Replace command with long formulas or strings
289629 "An
unexpected error has occurred" when you update links from Web browser
303809 Drawing objects on charts move after you save and reopen
304442 Excel
2000 may fault in MSO9.DLL when calling an XLL function that takes an
array
305694 ALT+TAB does not trigger Workbook_WindowActivate event
278679 "This workbook (document) has been password protected" when you open workbook
or document
305949 CPU
usage spikes at 100 percent when Excel is running in the background
297883 You
can see other users' printers in a terminal server session
307609 Borders of AutoShape on embedded Excel chart change thickness when
printed
307809 Excel
stops responding when you drag an item in the PivotTable Layout
Wizard
309671 SR-1 stops responding when you open a file after an incomplete save
291110 Cannot use keyboard shortcuts to select ranges in RefEdit control
311749 Combo box control on a worksheet returns to its original value after refresh
316399 Error message: No RETURN() or HALT() function found on macro sheet
316479 Contents of PivotTable disappear when data is updated in a different language version of Excel
317782 "Error -2147417848" occurs when data fields are added to a PivotTable from
VBA
317850 Excel stops responding when you run VBA macro code that displays a user
form
318063 Cannot set the Orientation property of a pivot field
320520 Excel quits unexpectedly when you switch between tab strip and chart on
worksheet
321244 Drawings in files that are created in versions of Excel before Excel 97 are not displayed correctly
323785 Processor spikes at 100 percent when you click AutoFilter arrow
324312 You cannot reopen a file after you save it
320262 VBA
error on macro startup if you open multiple Excel instances with RefEdit
control
324391 Excel quits when GetPivotData function is in second workbook
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-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.