fill series is incorrectly copying result

[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!

[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

"Roxy" wrote:

> 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!

[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.

"Roxy" wrote:

> 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!