copying formulas and not values
 

I have built a inventory sheet with pivot tables and many equations for loss
and costs and i have used this sheet for many months without a problem.
However, in the last week when i went to change a formula things got a bit
wierd. I added another cell to the equation and went to drag the formula
through the entire coulum - ex (A1+B1-C1)=8... Excell copied the formula with
the correct cell refences(as it always has), but it copied the number (8) as
well all through the entire column. The formula was correct for each cell
below the previous one (A2+B2-C2) however it copied the 8 which is wrong
because it should equal a different total. but if i double click the cell to
check the references for the equation and then hit enter the correct total
appears. This sheet is huge and reworking the entire sheet would be a pain.
Please help

Thank you
Jeff

copying formulas and not values
 

Is it possible you have the Calculation set to Manual? Try pressing F9 and
see if it recalculates.

"peets" wrote:

I have built a inventory sheet with pivot tables and many equations for loss
and costs and i have used this sheet for many months without a problem.
However, in the last week when i went to change a formula things got a bit
wierd. I added another cell to the equation and went to drag the formula
through the entire coulum - ex (A1+B1-C1)=8... Excell copied the formula with
the correct cell refences(as it always has), but it copied the number (8) as
well all through the entire column. The formula was correct for each cell
below the previous one (A2+B2-C2) however it copied the 8 which is wrong
because it should equal a different total. but if i double click the cell to
check the references for the equation and then hit enter the correct total
appears. This sheet is huge and reworking the entire sheet would be a pain.
Please help

Thank you
Jeff

copying formulas and not values
 

Try using "Paste Special"...

Select your "source"
Press Control-C to Copy
Select your Destination (which may be several cells)
Press Alt-E -- S (for special) -- F (for Formulas)

Aside from that...I'm not sure what you mean by the "8" value...

This LOOKS like a formula to return TRUE/FALSE depending on
IF the sum equals eight. If thatt is what you want, then perhaps
your "8" should also be a value that refers to another CELL which
has the value 8 stored in it.
This would also allow you to change the comparison value for
the formula in hundreds of cells, with ONE cell being updated.

Hope it helps,
Joseph in Atlanta

"peets" wrote:

I have built a inventory sheet with pivot tables and many equations for loss
and costs and i have used this sheet for many months without a problem.
However, in the last week when i went to change a formula things got a bit
wierd. I added another cell to the equation and went to drag the formula
through the entire coulum - ex (A1+B1-C1)=8... Excell copied the formula with
the correct cell refences(as it always has), but it copied the number (8) as
well all through the entire column. The formula was correct for each cell
below the previous one (A2+B2-C2) however it copied the 8 which is wrong
because it should equal a different total. but if i double click the cell to
check the references for the equation and then hit enter the correct total
appears. This sheet is huge and reworking the entire sheet would be a pain.
Please help

Thank you
Jeff