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

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

On This Page

SUMMARY

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

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

MORE INFORMATION

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 "#VALUE!" 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:
#VALUE!


Excel 2003 stops responding if you switch to another program while the "cell validation" dialog box is open

If you have a worksheet that requires "cell validation", and you switch to a different program while the "cell validation" 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.


"Cell validation" error message if you have a worksheet that requires "cell validation" and you type an invalid value for the "cell validation"

If you have a worksheet that requires "cell validation", and you type an invalid value for the "cell validation", you receive a "cell validation" error message. If you click Retry, and then you switch to a different program while the "cell validation" 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 "Unknown error" error message or a "Cannot connect to the server... " error message.


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

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.

Properties

Article ID: 872835 - Last Review: July 27, 2004 - Revision: 1.2
APPLIES TO
  • Microsoft Office Excel 2003
Keywords: 
kbupdate kbtshoot kbfix KB872835

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