Microsoft KB Archive/100022

Mac Works: Updating Calculated Fields in DB with Over 128 Fields

PSS ID Number: Q100022 Article last modified on 10-22-1998

3.0

MACINTOSH

=
========================================================= 3.00 MACINTOSH kbother kbprb

= SYMPTOMS =

In a Microsoft Works Database document, calculated fields created after the one-hundredth-twenty-eighth field created are not updated automatically.

= WORKAROUND =

To make a calculated field update correctly when information is entered in a cell affecting it, create the calculated field before the one-hundredth- twenty-eighth field created. It can then be moved anywhere else in the database and function correctly.

= STATUS =

Microsoft has confirmed this to be a problem in Works version 3.0. This problem no longer occurs in Microsoft Works version 4.0.

KBCategory: kbother kbprb KBSubcategory: mwksdb macworkskb

Additional reference words: 3.00 recalculate 128th more than over formula formulas ====================================================================== Version : 3.0 Platform : MACINTOSH Issue type : kbprb ============================================================================= Copyright Microsoft Corporation 1998.