Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|