Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Total Row Displays a Zero (0) or a #DIV/0! Error for All Columns

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

View products that this article applies to.

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.

↑ Back to the top

Workaround

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

↑ Back to the top

Keywords: KB828383, kbprb

↑ Back to the top

Article Info
Article ID : 828383
Revision : 4
Created on : 1/11/2006
Published on : 1/11/2006
Exists online : False
Views : 243