Microsoft KB Archive/836031

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

Article ID: 836031

Article Last Modified on 3/22/2005

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-





INTRODUCTION
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



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 &quot;The file may have been changed...&quot; 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 &quot;Unable To Read File&quot; 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 &quot;Excel cannot complete this task with available resources&quot; 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 &quot;Object&quot; 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: &quot;Unable to Read File&quot; 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: &quot;Unable to Read File&quot; 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 &quot;Cannot run 'MSQUERY.EXE'&quot; 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 &quot;MSQuery.exe&quot;

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 &quot;-2147417848 Method 'Style' of object 'Range' failed&quot; 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 &quot;Unexpected Error&quot; 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 &quot;Unexpected error&quot; 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 &quot;Unable to derive parameter information when parameter marker is a function argument&quot; 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.

Additional query words: 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

Keywords: kbservicepack kbinfo KB836031

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.