WD2000: Incorrect Total When Table Has More Than 85 Rows
Article ID: 193881
Article Last Modified on 12/6/2000
APPLIES TO
- Microsoft Word 2000 Standard Edition
This article was previously published under Q193881
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).
NOTE: The SUM and COUNT formulas can use the (ABOVE) and (BELOW) ranges.
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
- On the Tools menu, click Options, and then click the View tab.
- Under Show, click to select the Field Codes check box.
- Click OK.
The formula field looks similar to the following:
- Type a cell reference in the field. Change your field so that it
looks similar to the following
where A1 and A87 represent the first and last cells in the range.
- Press F9.
The field is updated.
- On the Tools menu, click Options, and then click the View tab.
- Under Show, click to clear the Field Codes check box.
- Click OK.
Method 2
Create subtotals, and then reference the subtotals to create a grand total.
Method 3
Use Excel to calculate totals.
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: kbbug kbnofix KB193881