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:
Excel 2002 Post-Service Pack 2 Hotfix Package: July 11, 2003
Excel 2002 Post-Service Pack 2 Hotfix Package: August 10, 2003
Excel 2002 Post-Service Pack 2 Hotfix Package: August 28, 2003
Excel 2002 Post-Service Pack 2 Hotfix Package: September 19, 2003
Excel 2002 Post-Service Pack 2 Hotfix Package: September 25, 2003
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:
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
You cannot change a link path when an Excel Add-In is not loaded
XL2002: Excel Abruptly Quits When You Save a Workbook
"Unable To Read File" Error Message When You Open a Workbook and Try to Update Links
Using a field alias in Query does not work with some third-party databases
XL2002: You Cannot Open Excel Files in Windows Explorer After You Use the Text Import Wizard
XL2002: VBA Error on Macro Startup If You Open Multiple Excel Instances with RefEdit Control
XL2002: Pivot Table Fields Do Not Function After Excel Repairs and Recovers File
You Receive Error Messages When You Delete Multiple Columns from a Graph
XL2002: The CPU Usage Is 100 Percent When You Copy a Large Sheet in Excel
XL2002 : Hyperlink Syntax Does Not Save Correctly When You Save an Excel File as an HTML Page
XL2002: Excel Stops Responding When Subtotals Are Removed
XL2002: Edits to PivotTables Do Not Bring Back New Columns
AutoCalculate feature is working even if that feature is turned off
XL2002: Workbook Is Slow to Open
XL2002: Workbook Unexpectedly Closes Immediately After You Open It
XL2002: Excel Quits When You Click an ActiveX Control
Excel 2002: Custom Toolbars Are Lost After You Quit Excel
XL2002: Excel May Stop Responding If You Call Calculate from an Asynchronous COM Event
XL2002: Excel May Stop Responding When You Try to Edit a Long Formula That Contains a Link
"Excel cannot complete this task with available resources" error message when you try to view the tracked changes in Excel 2002
XL2002: Excel Appears to Stop Responding When You Remove Subtotals
Data Labels Disappear If Value Is Greater Than Axis Maximum
Cannot see data that you copy from Excel 2002 in FrontPage 2002 preview
XL2002: An Additional "Object" Workbook Opens and Excel Appears to Stop Responding
XL2002: Combo Box Values Revert to Defaults After Another Combo Box Is Used
XL2002: You Cannot Update Links to Files on Secure Web Server
XL2002: "Unable to Read File" Error Message When You Open a Workbook
XL2002: Links in OLE Object Do Not Automatically Update When You Open a File in Windows Explorer
XL2002: Excel Appears to Stop Responding While Converting Text to Columns in Earlier Version Worksheet
XL2002: Excel Data Changes Font Format After You Edit the Excel Data in Word
OFFXP: Labels in Pasted Excel Chart Object Are Distorted, Unreadable, or Incomplete
XL2002: Time Calculation in Pivot Table May Not Be Accurate
XL2002: "Unable to Read File" Error Message When You Open Excel File That Contains a PivotTable Report
XL2002: Comments Appear in the Wrong Place in Workbook Saved As Web Page
XL2002: Excel Quits When You Draw a Connector Line on a Chart
XL2002: DDE Clients Cannot Use a RUN Command to Run an Inline Macro After a Security Update
XL2002: Workbook Does Not Print When You Use Excel on a Tablet PC
XL2002: Error Message: Run-Time Error:'13' Type Mismatch
Incorrect file origin is listed when you open a text file in Excel 2002
XL2002: Date Formats Are Lost When You Programmatically Move Data from One Range to Another
XL2002: Some Text Box Hyperlinks Do Not Work After You Save a Workbook As a Web Page
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)':
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 0000cdd2excel.exe 10.0.4524.0 msctf.dll 5.1.2600.1106 0000cdcbexcel.exe 10.0.4524.0 msctf.dll 5.1.2409.22 0001009dexcel.exe 10.0.4302.0 msctf.dll 5.1.2600.0 19264excel.exe 10.0.3506.0 msctf.dll 5.1.2600.0 19264
Additionally, other program versions, module versions, and offsets are possible.
xl2002 xl2k2 hangs crashes freezes security_patch security_update update security bug context flaw vulnerability malicious attacker exploit registry unauthenticated specially-formed scope specially-crafted affected