software

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
quot;paste specialquot; and making sure that I'm copying the formula. I've also
tried the quot;formula auditingquot; 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 thanks1) 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

quot;Alisonquot; gt; wrote in message
...
gt; Hi
gt;
gt; I'm trying to copy formulas across rows in a spreadsheet and getting a
gt; result as if I am pasting the value but not the formula (which is not what
gt; I'm doing)
gt;
gt; I'm finding that even though the pasted formula reads as referring
gt; correctly to the cells in the row that it's pasted to, the cell is showing
gt; the value of the cell that I copied the formula from. I've tried doing
gt; quot;paste specialquot; and making sure that I'm copying the formula. I've also
gt; tried the quot;formula auditingquot; function under the tools menu and it shows
gt; the
gt; correct formula, and the correct values in the calculation, but then goes
gt; onto give the value in the cell the formula's copied from. I'm completely
gt; stuck. Can anyone help?
gt;
gt; Many thanks
gt;
You're right - problem solved.

Thanks Bernard

quot;Bernard Liengmequot; wrote:

gt; 1) Is Calculation set to Manual? Use Tools | Options and open Calcualtions
gt; tab to see.
gt; 2) Would you like to show us the formula?
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Alisonquot; gt; wrote in message
gt; ...
gt; gt; Hi
gt; gt;
gt; gt; I'm trying to copy formulas across rows in a spreadsheet and getting a
gt; gt; result as if I am pasting the value but not the formula (which is not what
gt; gt; I'm doing)
gt; gt;
gt; gt; I'm finding that even though the pasted formula reads as referring
gt; gt; correctly to the cells in the row that it's pasted to, the cell is showing
gt; gt; the value of the cell that I copied the formula from. I've tried doing
gt; gt; quot;paste specialquot; and making sure that I'm copying the formula. I've also
gt; gt; tried the quot;formula auditingquot; function under the tools menu and it shows
gt; gt; the
gt; gt; correct formula, and the correct values in the calculation, but then goes
gt; gt; onto give the value in the cell the formula's copied from. I'm completely
gt; gt; stuck. Can anyone help?
gt; gt;
gt; gt; Many thanks
gt; gt;
gt;
gt;
gt;