G Guest Jan 6, 2007 #1 When I copy a formula the formula is correct, but the answer is the same as the original location
N Nick Hodge Jan 6, 2007 #2 John Most likely Tools>Options...>Calculation>Automatic or Your formula has absolute references with lots of $ around the formula e.g =SUM($A$1:$B$1) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed) www.nickhodge.co.uk
John Most likely Tools>Options...>Calculation>Automatic or Your formula has absolute references with lots of $ around the formula e.g =SUM($A$1:$B$1) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed) www.nickhodge.co.uk
