List of issues in Excel 2002 that are fixed by Office XP Service Pack 3

Article translations Article translations
Article ID: 836031 - View products that this article applies to.
Expand all | Collapse all

On This Page

SUMMARY

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:
832671 Description of Microsoft Office XP Service Pack 3

MORE INFORMATION

Excel 2002 issues that are fixed by Office XP SP3

The update fixes the issues that are described in the following Microsoft Hotfix Package articles:

823338 Excel 2002 Post-Service Pack 2 Hotfix Package: July 11, 2003
823969 Excel 2002 Post-Service Pack 2 Hotfix Package: August 10, 2003
827143 Excel 2002 Post-Service Pack 2 Hotfix Package: August 28, 2003
827978 Excel 2002 Post-Service Pack 2 Hotfix Package: September 19, 2003
827984 Excel 2002 Post-Service Pack 2 Hotfix Package: September 25, 2003
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:
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
817578 You cannot change a link path when an Excel Add-In is not loaded
822380 XL2002: Excel Abruptly Quits When You Save a Workbook
823026 "Unable To Read File" Error Message When You Open a Workbook and Try to Update Links
298955 Using a field alias in Query does not work with some third-party databases
320516 XL2002: You Cannot Open Excel Files in Windows Explorer After You Use the Text Import Wizard
321286 XL2002: VBA Error on Macro Startup If You Open Multiple Excel Instances with RefEdit Control
322238 XL2002: Pivot Table Fields Do Not Function After Excel Repairs and Recovers File
323613 You Receive Error Messages When You Delete Multiple Columns from a Graph
324051 XL2002: The CPU Usage Is 100 Percent When You Copy a Large Sheet in Excel
324125 XL2002 : Hyperlink Syntax Does Not Save Correctly When You Save an Excel File as an HTML Page
324557 XL2002: Excel Stops Responding When Subtotals Are Removed
325207 XL2002: Edits to PivotTables Do Not Bring Back New Columns
325703 AutoCalculate feature is working even if that feature is turned off
327365 XL2002: Workbook Is Slow to Open
328196 XL2002: Workbook Unexpectedly Closes Immediately After You Open It
330157 XL2002: Excel Quits When You Click an ActiveX Control
330345 Excel 2002: Custom Toolbars Are Lost After You Quit Excel
331401 XL2002: Excel May Stop Responding If You Call Calculate from an Asynchronous COM Event
331505 XL2002: Excel May Stop Responding When You Try to Edit a Long Formula That Contains a Link
331863 "Excel cannot complete this task with available resources" error message when you try to view the tracked changes in Excel 2002
811157 XL2002: Excel Appears to Stop Responding When You Remove Subtotals
811161 Data Labels Disappear If Value Is Greater Than Axis Maximum
811207 Cannot see data that you copy from Excel 2002 in FrontPage 2002 preview
811344 XL2002: An Additional "Object" Workbook Opens and Excel Appears to Stop Responding
811541 XL2002: Combo Box Values Revert to Defaults After Another Combo Box Is Used
811542 XL2002: You Cannot Update Links to Files on Secure Web Server
812384 XL2002: "Unable to Read File" Error Message When You Open a Workbook
812647 XL2002: Links in OLE Object Do Not Automatically Update When You Open a File in Windows Explorer
812668 XL2002: Excel Appears to Stop Responding While Converting Text to Columns in Earlier Version Worksheet
814020 XL2002: Excel Data Changes Font Format After You Edit the Excel Data in Word
815196 OFFXP: Labels in Pasted Excel Chart Object Are Distorted, Unreadable, or Incomplete
816997 XL2002: Time Calculation in Pivot Table May Not Be Accurate
819853 XL2002: "Unable to Read File" Error Message When You Open Excel File That Contains a PivotTable Report
820432 XL2002: Comments Appear in the Wrong Place in Workbook Saved As Web Page
821078 XL2002: Excel Quits When You Draw a Connector Line on a Chart
821136 XL2002: DDE Clients Cannot Use a RUN Command to Run an Inline Macro After a Security Update
821273 XL2002: Workbook Does Not Print When You Use Excel on a Tablet PC
821292 XL2002: Error Message: Run-Time Error:'13' Type Mismatch
821456 Incorrect file origin is listed when you open a text file in Excel 2002
821564 XL2002: Date Formats Are Lost When You Programmatically Move Data from One Range to Another
826091 XL2002: Some Text Box Hyperlinks Do Not Work After You Save a Workbook As a Web Page
827270 Excel Quits Unexpectedly with an Error Message When You Close an Excel Workbook That Contains DDE Links
Additional issues that are fixed by Office XP SP3
Additionally, the issues in this section are also fixed by Office XP SP3.

Excel quits unexpectedly when you open an XML spreadsheet

In 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 character

Excel 2002 finds the wrong character when you search for a specific extended character.



The EnableItemSelection method does not work

If 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 xlStroke

When 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 workbook

When 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:
Error accessing file. Network connection may have been lost.
If you click OK, and then click Enable Macros, you may receive the following error message:
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 call

Excel 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 data

When 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 computer

When 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 responding

When 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)':

Automation error
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 macro

When you try to run a macro in an Excel workbook, you may receive the following runtime error message:
-2147417848 Method 'Style' of object 'Range' failed
If you comment out all the lines of code that perform some form formatting in the workbook, the macro functions without error.



Drawing objects move after you save an Excel 2002 workbook

When 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 authentication

When 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 query

When you create a new database query to retrieve data from an SQL server, you may receive the following error message:
ODBC SQL Server Driver
Unable to derive parameter information when parameter marker is a function argument.
When you click OK you receive the following error message:
ODBC SQL Server Driver
Invalid descriptor index


Excel file is opened by using OLE and then closed but Excel process does not quit

When 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 save

Excel 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 function

When 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 2002

You receive the following Excel 2002 error message:
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.
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:
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
Additionally, other program versions, module versions, and offsets are possible.

Properties

Article ID: 836031 - Last Review: September 12, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbservicepack kbinfo KB836031

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com