Formula help

C

Chris

Just recently som sort of issue is going on in excel for me.

I can create formulas no problem, but when I go to copy and paste it to
another cell it captures the formula, but returns the exact same value as the
cell copied even when the result should be totally different.

The only way I can get the new cell to rteturn the real value, woudl be to
either save the file or to double-click in the cell and reset the formula.
When working with a large number of copied and pasted cells, this doesnt work
well. If I save, I cant undo my last action, and its not scalable to double
click and reset 100 cells at a time.

Anyone ever heard of this, and possibley know the issue/fix?

Thanks,
Chris
 
M

Mike Lewis

Chris, I can recreate this problem when my calculation is
set to "manual", check under, tools / options /
calculation and make sure it is not set to manual

Good Luck

Mike
 
C

Chris

HI All... Thanks for your help.

I checked the automatically update calculations and it was already enabled.
When I checked another one and then back on it,...then it seems to work now.

Strange, but I think its all good now, so I appreciate the direction.


Thanks,
Chris
 
Top