WD97: Incorrect Total When Table Has More Than 85 Rows

WORKAROUND

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 updates.
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