Copy formulas - strange things happens

  • Thread starter Thread starter Pop
  • Start date Start date
P

Pop

I have a problem I have never seen before - I have a row of numbers that I
want to divide by 1000 - I do as I usually do +CELL/1000 - when I drag to
copy the formula down to the next cells I get the same number in all cells -
the reference looks OK - If I do it "manually" in all cells, it works ....

Does anybody have a clou on this ?
 
Make sure your wb is not set to manual calculation. Check
under Tools > Options > Calculation tab.

HTH
Jason
Atlanta, GA
 
Back
Top