Microsoft KB Archive/828383

= Total Row Displays a Zero (0) or a #DIV/0! Error for All Columns =

Article ID: 828383

Article Last Modified on 1/11/2006

-

APPLIES TO


 * Microsoft Office Excel 2003

-





SYMPTOMS
If all the following conditions exist, the total row displays a zero (0) or a #DIV/0! error for all columns:
 * A formula is selected.
 * The list is linked to Microsoft SharePoint.
 * Total row is turned on.
 * Manual Calculation is on.
 * The list is synchronized.



WORKAROUND
To work around this issue, either press F9 to recalculate the worksheet or type new data in the list.

Keywords: kbprb KB828383

-

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

© Microsoft Corporation. All rights reserved.