The information in this article applies to:
SYMPTOMS
When you update a formula field in a table, the result is incorrect if
the following are true:
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...) 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. Additional query words: wrong bad limit error
Keywords : kbdta wd2000 |
Last Reviewed: July 15, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |