Why would a pasted formula not calculate the new cell refs?
 

Hi

I'm trying to copy formulas across rows in a spreadsheet and getting a
result as if I am pasting the value but not the formula (which is not what
I'm doing)

I'm finding that even though the pasted formula reads as referring
correctly to the cells in the row that it's pasted to, the cell is showing
the value of the cell that I copied the formula from. I've tried doing
"paste special" and making sure that I'm copying the formula. I've also
tried the "formula auditing" function under the tools menu and it shows the
correct formula, and the correct values in the calculation, but then goes
onto give the value in the cell the formula's copied from. I'm completely
stuck. Can anyone help?

Many thanks

Why would a pasted formula not calculate the new cell refs?
 

1) Is Calculation set to Manual? Use Tools | Options and open Calcualtions
tab to see.
2) Would you like to show us the formula?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Alison" wrote in message
...
Hi

I'm trying to copy formulas across rows in a spreadsheet and getting a
result as if I am pasting the value but not the formula (which is not what
I'm doing)

I'm finding that even though the pasted formula reads as referring
correctly to the cells in the row that it's pasted to, the cell is showing
the value of the cell that I copied the formula from. I've tried doing
"paste special" and making sure that I'm copying the formula. I've also
tried the "formula auditing" function under the tools menu and it shows
the
correct formula, and the correct values in the calculation, but then goes
onto give the value in the cell the formula's copied from. I'm completely
stuck. Can anyone help?

Many thanks

Why would a pasted formula not calculate the new cell refs?
 

You're right - problem solved.

Thanks Bernard

"Bernard Liengme" wrote:

1) Is Calculation set to Manual? Use Tools | Options and open Calcualtions
tab to see.
2) Would you like to show us the formula?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Alison" wrote in message
...
Hi

I'm trying to copy formulas across rows in a spreadsheet and getting a
result as if I am pasting the value but not the formula (which is not what
I'm doing)

I'm finding that even though the pasted formula reads as referring
correctly to the cells in the row that it's pasted to, the cell is showing
the value of the cell that I copied the formula from. I've tried doing
"paste special" and making sure that I'm copying the formula. I've also
tried the "formula auditing" function under the tools menu and it shows
the
correct formula, and the correct values in the calculation, but then goes
onto give the value in the cell the formula's copied from. I'm completely
stuck. Can anyone help?

Many thanks