Microsoft KB Archive/180752

= MacWD: Incorrect Total When Table Has More Than 85 Rows =

Article ID: 180752

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft Word 2001 for Mac
 * Microsoft Word 98 for Macintosh

-



This article was previously published under Q180752





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 work around 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 resembles the following:

{=Sum(Above)}

 Type a cell reference in the field. Change your field so that it resembles the following

{=Sum(A1:A87)}

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.</li> Under Show, click to clear the Field Codes check box.</li> Click OK.</li></ol>

Method 2
Create subtotals, and then reference the subtotals to create a grand total.

Method 3
Use Excel to calculate totals.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="moreinformation_section">

MORE INFORMATION
For additional information on the Formula field, please see the following article in the Microsoft Knowledge Base:

185401 WD98: How to Set Up a Table as a Spreadsheet in Word

Additional query words: wrong bad limit error

Keywords: kbpending kbprb kbtable KB180752

-

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

© Microsoft Corporation. All rights reserved.