Sign in with
Sign up | Sign in
Your question

excel copy paste problem

Last response: in Applications
Share
March 4, 2014 9:20:06 AM

copying the formula sum(a1:a3) from a4 to b4 does show sum(b1:b3) in the b4 cell, but, value is still the same as a4. Changing a character (eg deleting and reentering the 3 in sum(b1:b3)) gets the correct value.
March 4, 2014 6:42:15 PM

Check "Recalculation" options, you might have turned them off.
m
0
l
!