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



The information in this article 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.

Modification Type:MinorLast Reviewed:1/11/2006
Keywords:kbprb KB828383 kbAudEndUser