The information in this article applies to:
SYMPTOMSWhen you update a formula field in a table, the result is incorrect if the following are true:
When you use a Visual Basic for Applications procedure that uses the AutoSum Method to insert the formula field, the following error appears in place of the formula field when the number of summed rows total more than 85:
CAUSEThis 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[ASCII 133]) and eventually it gets too long for the string. WORKAROUNDUse one of the following methods to workaround this problem: Method 1 - Specify a range cell reference in the formula
{=Sum(Above)} Method 2Create subtotals, and then reference the subtotals to create a grand total.Method 3Use Excel to calculate totals.STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed
at the beginning of this article. MORE INFORMATIONFor additional information on the Formula field, please see the following article in the Microsoft Knowledge Base: Q185400 WD97: How to Set Up a Table as a Spreadsheet in Word Additional query words: 8.0
Keywords : kbusage kbdta kbfield kbtable |
Last Reviewed: September 15, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |