WD2000: Incorrect Total When Table Has More Than 85 Rows

• Microsoft Word 2000

SYMPTOMS

When you update a formula field in a table, the result is incorrect if the following are true:

• The table contains more than 85 rows.
  
  -and-



• The range specified in the formula is (ABOVE) or (BELOW).

CAUSE

This problem occurs when a finite length string is overrun because too many cells are referenced in the formula. The field =Sum(Above) is translated to =Sum(a1+b1+c1...) and eventually it gets too long for the string.

WORKAROUND

Use one of the following methods to workaround this problem:

Method 1 - Specify a range cell reference in the formula

1. On the Tools menu, click Options, and then click the View tab.



2. Under Show, click to select the Field Codes check box.



3. Click OK.
   
   The formula field looks similar to the following:




{=Sum(Above)}

4. Type a cell reference in the field. Change your field so that it looks similar to the following

   {=Sum(A1:A87)}

   where A1 and A87 represent the first and last cells in the range.



5. Press F9.
   
   The field is updated.



6. On the Tools menu, click Options, and then click the View tab.



7. Under Show, click to clear the Field Codes check box.



8. Click OK.

Method 2

Method 3

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: wrong bad limit error

Keywords          : kbdta wd2000 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: July 15, 1999