easy formula not working

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I have a file a friend is having trouble with. He put =t5
in cell u5. It returned the value in t5. He then drags
the formula down to u20. Although the formulas look
correct in each cell (u6-u20) the values returned not
correct but have the same number as is in t5--the original
reference. I had him send me the file and it's messed up
on my machine too. Then I created a new test file and put
some random #s in and created and dragged the formula
down. Works fine on my system. Same test on his returns
identical problem as original file. I looked in the KB.
Any ideas? Thanks in advance.
 
Calculation may be set to manual on your friend's computer. To check,
choose Tools>Options. On the Calculation tab, select Automatic.
 
Back
Top