fill series is incorrectly copying result
 

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!

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!

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!