Microsoft KB Archive/872835

= Issues that are fixed in Excel 2003 by Office 2003 Service Pack 1 =

Article ID: 872835

Article Last Modified on 7/27/2004

-

APPLIES TO


 * Microsoft Office Excel 2003

-



SUMMARY
''Microsoft has released a Microsoft Office 2003 service pack for Microsoft Office Excel 2003. The following &quot;Article contents&quot; section describes the information that this article contains about the service pack.''



Article contents

 * INTRODUCTION
 * MORE INFORMATION
 * List of issues that are fixed in the service pack
 * Earlier released updates that are included in the service pack
 * Error signature details



INTRODUCTION
Microsoft Office 2003 Service Pack 1 (SP1) provides the latest updates to Office 2003. Office 2003 SP1 contains significant security enhancements and stability and performance improvements.

For additional information about Office 2003 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

842532 Description of Office 2003 Service Pack 1

back to the top



List of issues that are fixed in the service pack
Office 2003 SP1 fixes the issues that are described in the following hotfix packages:

834691 Description of Excel 2003 update: March 23, 2004

835741 Excel 2003 hotfix package: March 5, 2004

837258 Excel 2003 hotfix package: April 12, 2004

Office 2003 SP1 fixes the following issues that were not previously documented in the Microsoft Knowledge Base.

Values change to &quot;#VALUE!&quot; when you press CTRL+SHIFT+ALT+F9 to recalculate a range in your workbook
When you press CTRL+SHIFT+ALT+F9 to recalculate a range in your workbook that contains multiple LINEST formulas that reference the same range, the values change to the following:


 * 1) VALUE!

Excel 2003 stops responding if you switch to another program while the &quot;cell validation&quot; dialog box is open
If you have a worksheet that requires &quot;cell validation&quot;, and you switch to a different program while the &quot;cell validation&quot; dialog box is open, Excel 2003 may stop responding (hang) and any other program that is running may stop responding (hang).

Subtotals or grand totals may be incorrect when a pivot table calculates any form of the VAR function, the VARP function, the STDEV function, or the STDEVP function
When a pivot table that contains subtotals or grand totals is calculating any form of the following functions, the subtotals or the grand totals may be incorrect:
 * VAR
 * VARP
 * STDEV
 * STDEVP

#NUM is returned when a HYPGEOMDIST formula returns an incorrect value
When a HYPGEOMDIST formula returns an incorrect value or a value that is not valid, instead of returning #VALUE as in earlier versions of Microsoft Excel, Excel 2003 returns #NUM.

Note #NUM and #VALUE are error messages that appear in the cell that contains the formula when the result of the formula is not valid.

NORMSDIST function may return incorrect values that are more than seven decimal places
When you use the NORMSDIST function, you may receive incorrect values that are more than seven decimal places.

Excel 2003 menus and toolbars appear in the designer window when you edit an Excel 2003 chart in the Visual Studio Designer
When you right-click an Excel 2003 chart to edit it in the Visual Studio Designer, Excel 2003 menus and toolbars may appear in the designer window.

&quot;Cell validation&quot; error message if you have a worksheet that requires &quot;cell validation&quot; and you type an invalid value for the &quot;cell validation&quot;
If you have a worksheet that requires &quot;cell validation&quot;, and you type an invalid value for the &quot;cell validation&quot;, you receive a &quot;cell validation&quot; error message. If you click Retry, and then you switch to a different program while the &quot;cell validation&quot; dialog box is open, both Excel 2003 and any other program that is running may stop responding (hang).

Error messages or Excel 2003 stops responding when you publish to a secure Microsoft Windows SharePoint Services server
When you try to publish to a secure Windows SharePoint Services server, Excel 2003 may appear to stop responding for a long time, and then you receive an &quot;Unknown error&quot; error message or a &quot;Cannot connect to the server... &quot; error message.

back to the top

Earlier released updates that are included in the service pack
Office 2003 SP1 includes these earlier released updates:

834691 Description of Excel 2003 update: March 23, 2004

back to the top

Error signature details
You may receive an error message that is similar to the following when you use Excel 2003:

Microsoft Office 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:   Application name  Application version  Module name   Module version  Offset -  Excel.exe         11.0.5612.0          Mso.dll       11.0.5703.0     0003dc75 Excel.exe        11.0.5612.0          Unknown       0.0.0.0         00000000 Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     0003c260 Excel.exe        11.0.5612.0          Mso.dll       11.0.5606.0     0006ba64 Excel.exe        11.0.6113.0          Excel.exe     11.0.6113.0     000aa419 Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     0038eb7f Excel.exe        11.0.6113.0          Excel.exe     11.0.6113.0     0038ebfb Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     000b6a9d Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     000297ce Excel.exe        11.0.5612.0          Mso.dll       11.0.5606.0     0003d84e Excel.exe        11.0.5329.7          Excel.exe     11.0.5329.7     000109f48 Excel.exe        11.0.6113.0          Excel.exe     11.0.6113.0     000c027a Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     000c3fe9 Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     0002edc1 Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     000f50ae Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     000d740e Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     007a5736 Excel.exe        11.0.6113.0          Excel.exe     11.0.6113.0     007a5b5a Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     000b3701 Excel.exe        11.0.6113.0          Excel.exe     11.0.6113.0     000b9054 Excel.exe        11.0.5612.0          Excel.exe     11.0.5612.0     0028c6e3 Excel.exe        11.0.5612.0          Mso.dll       11.0.5606.0     004db3b0 Additionally, other program versions, module versions, and offsets are possible.

back to the top

Keywords: kbtshoot kbfix kbupdate KB872835

-

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

© Microsoft Corporation. All rights reserved.