Microsoft KB Archive/27416

{|
 * width="100%"|

Excel: Formulas Not Calculated After Fill Command

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0

-

SUMMARY
In Microsoft Excel, after you choose one of the Fill commands (Fill Down, Fill Right) from the Edit menu to copy formulas down a column or across a row, the values will not change to reflect the calculations for the following reasons:


 * 1) Automatic Calculation has been turned off. To calculate the values, do one of the following:

a. Turn on automatic calculation by choosing Calculation from the Options menu and selecting Automatic.

-or-

b. Manually calculate the document by choosing Calculate Now from the Options menu.
 * 1) The formula that has been filled contains absolute references rather than relative references. For example, the formula =$A$1+$B$1 contains absolute references; therefore, this exact formula will appear in any cell into which it is filled without updating the references. However, the formula =A1+B1 will fill correctly.
 * 2) The sheet where the Fill Down operation was performed is a macro sheet. Macro sheets do not update the values of formulas until the macro containing the formulas is run.

Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :