Microsoft KB Archive/126808

= Works: Self-Referencing Formula Does Not Update Automatically =

Article ID: 126808

Article Last Modified on 10/6/2003

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b

-



This article was previously published under Q126808



SYMPTOMS
Self-referencing formulas in the Database module do not automatically recalculate when a record is deleted.



WORKAROUND
Method 1:

Save, close and reopen the file. Works will recalculate the formula.

Method 2:

Manually re-enter any entry in any field that is being referenced by the formula. To quickly re-enter data, press the F2 key and then press Enter.



STATUS
This problem has been fixed in Works 4.0, 4.5, and 4.5a for Windows 95.



MORE INFORMATION
A self-referencing formula uses the name of the field in which it is entered. For example, the following formula entered in a database field named "Balance" would be self-referencing: =Balance-Check+Deposit

Additional query words: 2.00 2.00a 3.00 3.00a 3.00b w_works reference updated running total

Keywords: kbprb KB126808

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.