WD97: Incorrect Total When Table Has More Than 85 Rows

• Microsoft Word 97 for Windows

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

WORKAROUND

To work around this problem, specify the range as a cell reference:

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.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

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

   ARTICLE-ID: Q142507
   TITLE     : How to Set Up a Table as a Spreadsheet in Word