Excel formulas

R

Rolaxis

Whenever I copy a cell with a formula to a new cell, the results are the same
in the target cell as it was in the source cell. It doesn't matter what the
values are in any cell.
 
D

Dave O

The spreadsheet may be set to manual recalculation: press F9 to see if
you get the results you expect. If this is the case and you'd prefer
calculation to be automatic, click >Tools >Options and select the
Calculation tab; select Automatic.
 
R

Rolaxis

Dave O said:
The spreadsheet may be set to manual recalculation: press F9 to see if
you get the results you expect. If this is the case and you'd prefer
calculation to be automatic, click >Tools >Options and select the
Calculation tab; select Automatic.

Thanks! that was the solution.
Click to expand...
 
A

Any answer?

Rolaxis said:
Whenever I copy a cell with a formula to a new cell, the results are the same
in the target cell as it was in the source cell. It doesn't matter what the
values are in any cell.
Click to expand...
 
Top