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.
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.