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

   {=Sum(Above)}

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