Microsoft KB Archive/27893

Mac Works: Formulas Not Calculated After Fill Down or Fill Right

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

1.0 1.1 2.0 3.0 4.0

MACINTOSH

=
=========================================================

= SUMMARY =

In the Spreadsheet module of Microsoft Works, after you use the Fill Down or Fill Right command on the Edit menu to copy formulas down a column or across a row, the values sometimes do not change to reflect the calculation based on the data values in the different rows.

This problem usually occurs because Automatic Calculation (on the Options menu) has been turned off. The correct calculated values will appear after you choose Calculate Now or Automatic Calculation from the Options menu.

This problem can also be caused by using absolute references rather than relative references. For example, the formula “=$A$1+$ A$2” uses absolute references and produces the same values in a filled range; the formula “=A1+A2” uses relative references and will calculate correctly.

KBCategory: kbusage kbprb KBSubcategory: macworkskb

Additional reference words: 1.00 1.10 2.00 3.00 4.00 mswksss mwksss macworks mwkswp ====================================================================== Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbprb ============================================================================= Copyright Microsoft Corporation 1998.