Article ID: 836031 - View products that this article applies to.
Microsoft has released Microsoft Office XP Service Pack 3 (SP3). This article describes the issues that are fixed for Microsoft Excel 2002. For additional information about how to download and install the Office XP SP3, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/832671/ )Description of Microsoft Office XP Service Pack 3
Excel 2002 issues that are fixed by Office XP SP3The update fixes the issues that are described in the following Microsoft Hotfix Package articles:
(http://support.microsoft.com/kb/823338/ )Excel 2002 Post-Service Pack 2 Hotfix Package: July 11, 2003
(http://support.microsoft.com/kb/823969/ )Excel 2002 Post-Service Pack 2 Hotfix Package: August 10, 2003
(http://support.microsoft.com/kb/827143/ )Excel 2002 Post-Service Pack 2 Hotfix Package: August 28, 2003
(http://support.microsoft.com/kb/827978/ )Excel 2002 Post-Service Pack 2 Hotfix Package: September 19, 2003
(http://support.microsoft.com/kb/827984/ )Excel 2002 Post-Service Pack 2 Hotfix Package: September 25, 2003
(http://support.microsoft.com/kb/829340/ )Excel 2002 Post-Service Pack 2 hotfix package: October 6, 2003
The update fixes the issues that are described in the following Microsoft Knowledge Base articles:
(http://support.microsoft.com/kb/324491/ )You receive "The file may have been changed..." error message when you save a workbook to a network server in Excel 2002 or in Excel 2003
(http://support.microsoft.com/kb/817578/ )You cannot change a link path when an Excel Add-In is not loaded
(http://support.microsoft.com/kb/822380/ )XL2002: Excel Abruptly Quits When You Save a Workbook
(http://support.microsoft.com/kb/823026/ )"Unable To Read File" Error Message When You Open a Workbook and Try to Update Links
(http://support.microsoft.com/kb/298955/ )Using a field alias in Query does not work with some third-party databases
(http://support.microsoft.com/kb/320516/ )XL2002: You Cannot Open Excel Files in Windows Explorer After You Use the Text Import Wizard
(http://support.microsoft.com/kb/321286/ )XL2002: VBA Error on Macro Startup If You Open Multiple Excel Instances with RefEdit Control
(http://support.microsoft.com/kb/322238/ )XL2002: Pivot Table Fields Do Not Function After Excel Repairs and Recovers File
(http://support.microsoft.com/kb/323613/ )You Receive Error Messages When You Delete Multiple Columns from a Graph
(http://support.microsoft.com/kb/324051/ )XL2002: The CPU Usage Is 100 Percent When You Copy a Large Sheet in Excel
(http://support.microsoft.com/kb/324125/ )XL2002 : Hyperlink Syntax Does Not Save Correctly When You Save an Excel File as an HTML Page
(http://support.microsoft.com/kb/324557/ )XL2002: Excel Stops Responding When Subtotals Are Removed
(http://support.microsoft.com/kb/325207/ )XL2002: Edits to PivotTables Do Not Bring Back New Columns
(http://support.microsoft.com/kb/325703/ )AutoCalculate feature is working even if that feature is turned off
(http://support.microsoft.com/kb/327365/ )XL2002: Workbook Is Slow to Open
(http://support.microsoft.com/kb/328196/ )XL2002: Workbook Unexpectedly Closes Immediately After You Open It
(http://support.microsoft.com/kb/330157/ )XL2002: Excel Quits When You Click an ActiveX Control
(http://support.microsoft.com/kb/330345/ )Excel 2002: Custom Toolbars Are Lost After You Quit Excel
(http://support.microsoft.com/kb/331401/ )XL2002: Excel May Stop Responding If You Call Calculate from an Asynchronous COM Event
(http://support.microsoft.com/kb/331505/ )XL2002: Excel May Stop Responding When You Try to Edit a Long Formula That Contains a Link
(http://support.microsoft.com/kb/331863/ )"Excel cannot complete this task with available resources" error message when you try to view the tracked changes in Excel 2002
(http://support.microsoft.com/kb/811157/ )XL2002: Excel Appears to Stop Responding When You Remove Subtotals
(http://support.microsoft.com/kb/811161/ )Data Labels Disappear If Value Is Greater Than Axis Maximum
(http://support.microsoft.com/kb/811207/ )Cannot see data that you copy from Excel 2002 in FrontPage 2002 preview
(http://support.microsoft.com/kb/811344/ )XL2002: An Additional "Object" Workbook Opens and Excel Appears to Stop Responding
(http://support.microsoft.com/kb/811541/ )XL2002: Combo Box Values Revert to Defaults After Another Combo Box Is Used
(http://support.microsoft.com/kb/811542/ )XL2002: You Cannot Update Links to Files on Secure Web Server
(http://support.microsoft.com/kb/812384/ )XL2002: "Unable to Read File" Error Message When You Open a Workbook
(http://support.microsoft.com/kb/812647/ )XL2002: Links in OLE Object Do Not Automatically Update When You Open a File in Windows Explorer
(http://support.microsoft.com/kb/812668/ )XL2002: Excel Appears to Stop Responding While Converting Text to Columns in Earlier Version Worksheet
(http://support.microsoft.com/kb/814020/ )XL2002: Excel Data Changes Font Format After You Edit the Excel Data in Word
(http://support.microsoft.com/kb/815196/ )OFFXP: Labels in Pasted Excel Chart Object Are Distorted, Unreadable, or Incomplete
(http://support.microsoft.com/kb/816997/ )XL2002: Time Calculation in Pivot Table May Not Be Accurate
(http://support.microsoft.com/kb/819853/ )XL2002: "Unable to Read File" Error Message When You Open Excel File That Contains a PivotTable Report
(http://support.microsoft.com/kb/820432/ )XL2002: Comments Appear in the Wrong Place in Workbook Saved As Web Page
(http://support.microsoft.com/kb/821078/ )XL2002: Excel Quits When You Draw a Connector Line on a Chart
(http://support.microsoft.com/kb/821136/ )XL2002: DDE Clients Cannot Use a RUN Command to Run an Inline Macro After a Security Update
(http://support.microsoft.com/kb/821273/ )XL2002: Workbook Does Not Print When You Use Excel on a Tablet PC
(http://support.microsoft.com/kb/821292/ )XL2002: Error Message: Run-Time Error:'13' Type Mismatch
(http://support.microsoft.com/kb/821456/ )Incorrect file origin is listed when you open a text file in Excel 2002
(http://support.microsoft.com/kb/821564/ )XL2002: Date Formats Are Lost When You Programmatically Move Data from One Range to Another
(http://support.microsoft.com/kb/826091/ )XL2002: Some Text Box Hyperlinks Do Not Work After You Save a Workbook As a Web Page
(http://support.microsoft.com/kb/827270/ )Excel Quits Unexpectedly with an Error Message When You Close an Excel Workbook That Contains DDE Links
Additionally, the issues in this section are also fixed by Office XP SP3.
Additional issues that are fixed by Office XP SP3
Excel quits unexpectedly when you open an XML spreadsheetIn Excel 2002, when you open XML spreadsheet that is generated in the Microsoft Office XP Spreadsheet Web Component, and run Print Preview, Excel may quit unexpectedly. The cause of this problem is insufficient printing information.
Excel 2002 finds the wrong character when you search for a specific extended characterExcel 2002 finds the wrong character when you search for a specific extended character.
The EnableItemSelection method does not workIf you use a OLAP source for pivot table in Excel 2002, your call to the EnableItemSelection method does not work and you may receive a VBA error 1004. This issue does not occur if the pivot table uses an SQL or an internal source for the data.
The constant for the sort method is xlStrokeWhen you record a macro of a phonetic sort of a column in Excel 2002, Chinese Traditional version, Excel 2002 uses the constant xlStroke for the sort method instead of the constant xlPinYin for the phonetic sort.
VBA modules are lost when you apply a digital signature to a workbookWhen you apply a digital signature to an Excel 2000 or Excel 97 workbook by using Excel 2002, VBA modules that belong to the workbook may be lost after you save the workbook. When you open the workbook, you may receive the following Microsoft Visual Basic error message:
If you click OK, and then click Enable Macros, you may receive the following error message:
Error accessing file. Network connection may have been lost.
Errors were detected in 'file_name.xls,' but Microsoft Excel was able to open the file by making repairs listed below. Save the file to make these repairs permanent.
Lost Visual Basic project.
Lost ActiveX controls.
Excel 2002 stops responding when you change the criteria parameter in the database function callExcel 2002 stops responding when using a database function, such as DSUM, when the criteria parameter for the function is based on a cell that is automatically filled by using the =Rand() function or the =RANDBETWEEN() function.
Excel 2002 does not correctly convert XML dataWhen you open an XML document by using Excel 2002, only the last element of each row in the XML data table imports into the worksheet.
You receive the "Cannot run 'MSQUERY.EXE'" error message on a Windows 98-based computerWhen you try to import external data into a workbook, the MSQuery program stops responding, or you receive the following error message:
Cannot run "MSQuery.exe"
The VBA HPageBreaks.Add method may cause Excel 2002 to stop respondingWhen you use a VBA macro to set page breaks in an Excel 2002 workbook, through use of the HPageBreaks.Add method, you may receive the following run-time error message:
Run-time error '-2147417848 (80010108)':
The object invoked has disconnected from its clients.
You receive the "-2147417848 Method 'Style' of object 'Range' failed" runtime error message when you run a VBA macroWhen you try to run a macro in an Excel workbook, you may receive the following runtime error message:
If you comment out all the lines of code that perform some form formatting in the workbook, the macro functions without error.
-2147417848 Method 'Style' of object 'Range' failed
Drawing objects move after you save an Excel 2002 workbookWhen you save an Excel 2002 workbook, any drawing objects, such as rectangles, ovals, and other objects may change position on the worksheet after you save, close, and then open the workbook.
Linked sheets may cause an "Unexpected Error" error message in a Web browser with Basic authenticationWhen you update a link from one Excel sheet to another Excel sheet, you will receive an "Unexpected error" error message. This issue occurs if the files are located on an Microsoft IIS Server with Basic Authentication and are opened in Microsoft Internet Explorer.
You receive the "Unable to derive parameter information when parameter marker is a function argument" error message when you create a new database queryWhen you create a new database query to retrieve data from an SQL server, you may receive the following error message:
When you click OK you receive the following error message:
ODBC SQL Server Driver
Unable to derive parameter information when parameter marker is a function argument.
ODBC SQL Server Driver
Invalid descriptor index
Excel file is opened by using OLE and then closed but Excel process does not quitWhen you open and close a specific Excel file by using object linking and embedding (OLE) automation, the Excel process does not quit as expected.
A shared Excel workbook quits unexpectedly when you try to saveExcel may quit unexpectedly when you open or when you save a shared Microsoft Excel workbook that contains custom views, and one or more of these views contains a multiple of 10 page breaks--for example, 10, 20, 30, and so on.
Data is lost when your Excel 2002 workbook contains data that was set by using a callback to the xlDefineBinaryName functionWhen you save a Microsoft Excel 2002 file that contains data that was set by using a callback to the xlDefineBinaryName function, if the workbook is password protected and the data is larger than the maximum bytes that can fit in a record, all the subsequent data is lost when you reopen the workbook.
You receive an error message in Excel 2002You receive the following Excel 2002 error message:
When you view the data in the error report, the report contains an error signature that is similar to one of the following error signatures:
Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience. To see what data this error report contains, click here.
Additionally, other program versions, module versions, and offsets are possible.
App Name App Version Module Name Module Version offset ------------------------------------------------------------------------ excel.exe 10.0.4524.0 msctf.dll 5.1.2600.1106 0000cdd2 excel.exe 10.0.4524.0 msctf.dll 5.1.2600.1106 0000cdcb excel.exe 10.0.4524.0 msctf.dll 5.1.2409.22 0001009d excel.exe 10.0.4302.0 msctf.dll 5.1.2600.0 19264 excel.exe 10.0.3506.0 msctf.dll 5.1.2600.0 19264