Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying formulas (relative) give always original value
I try to copy formulas in adjacent cells. whatever I do the <past special /
formulas function returns always the value in the original field. |
#2
|
|||
|
|||
Perhaps the calc mode was inadvertently switched to "Manual" instead of
"Automatic"? Click Tools Options Calculation tab Ensure that "Automatic" box is checked OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Eddyd" wrote in message ... I try to copy formulas in adjacent cells. whatever I do the <past special / formulas function returns always the value in the original field. |
#3
|
|||
|
|||
Thanks Max for trying to help me. unfortunately the "automatic" box was
checked already ... "Max" wrote: Perhaps the calc mode was inadvertently switched to "Manual" instead of "Automatic"? Click Tools Options Calculation tab Ensure that "Automatic" box is checked OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Eddyd" wrote in message ... I try to copy formulas in adjacent cells. whatever I do the <past special / formulas function returns always the value in the original field. |
#4
|
|||
|
|||
Maybe you could paste the *actual* formulas in the starting cell(s) that
you're trying to copy down / across? The key probably lies with the cell refs in the starting cell's formula that you want to copy down / across, whether these are absolute / fixed or relative refs, viz: with / without dollar ($) signs around the cell refs, e.g.: $A$1, $A1, A$1, A1. Having the dollar sign around the row / col ref will fix the row / col ref when you copy the formula down / across. So what it should be depends on what you want to remain fixed or to change relatively. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "EddyD" wrote in message ... Thanks Max for trying to help me. unfortunately the "automatic" box was checked already ... |
#5
|
|||
|
|||
Thank you Max. The problem seemed to be solved. When I clicked the starting
cells black cross and dragged it down, all the cells had the same figure as the starting cell, in spite of different amounts in the cells to be additioned. The same when I did it with the standard toolbars <Edit, where the normal <paste was greyed out. Using the icons however to paste the original cell's formula, gave the correct result. Thank you for helping me. "Max" wrote: Maybe you could paste the *actual* formulas in the starting cell(s) that you're trying to copy down / across? The key probably lies with the cell refs in the starting cell's formula that you want to copy down / across, whether these are absolute / fixed or relative refs, viz: with / without dollar ($) signs around the cell refs, e.g.: $A$1, $A1, A$1, A1. Having the dollar sign around the row / col ref will fix the row / col ref when you copy the formula down / across. So what it should be depends on what you want to remain fixed or to change relatively. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "EddyD" wrote in message ... Thanks Max for trying to help me. unfortunately the "automatic" box was checked already ... |
#6
|
|||
|
|||
Glad to hear you got it working !
Thanks for posting back .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "EddyD" wrote in message ... Thank you Max. The problem seemed to be solved. When I clicked the starting cells black cross and dragged it down, all the cells had the same figure as the starting cell, in spite of different amounts in the cells to be additioned. The same when I did it with the standard toolbars <Edit, where the normal <paste was greyed out. Using the icons however to paste the original cell's formula, gave the correct result. Thank you for helping me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Error when copying formulas | Excel Worksheet Functions | |||
excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel | |||
Relative addressing using names or labels in formulas? | Excel Worksheet Functions |