fill series is incorrectly copying result

R

Roxy

Is there a setting somewhere to solve the following:

User wants to use auto fill to copy her formulas down a column. When she
does this it is simply copying the answer from the previous cell. Although
the formula is correct in the formula bar the result is not.

This works incorrectly on any new workbook she opens.

Thanks!
 
D

Duke Carey

It's likely that your user has calculation set to manual.

Go to Tools->Options->Calculation and make sure the Automatic option is
selected
 
R

Roxy

I found the fix:

Just change the following:

Tools to Options to the Calculation Tab
Under Calculation make sure that automatic is selected. It was on manual.
 
Top