Excel 2002 Fill Handle give same answer?

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

When I pull the fill handle down it changes the formula
but all the answers are the same as the first cell's???
Basically the fill handle doesnt' work. Is this an
adjustment or a bug?

Jan
 
Hi
maybe you have disabled the automatic calcualtion. does hitting F9
change the results. If yes goto 'Tools - Options - Calculation' and
enable 'Automatic calculation'
 
Hi Jan

your calculation could be set to manual rather than automatic
tools / options / calculation tab

cheers
JulieD
 
Jan,

First, try doing a full recalc - Ctrl-Alt-F9. It should take care of it, if
your formula is written correctly.

If your formula is written with absolute references (using $s) then that's
what you would expect. Delete any $s that you don't truly need, and it
should work fine.

If you have further problems, post your formula.

HTH,
Bernie
MS Excel MVP
 
Automatic Calculation is enabled.
-----Original Message-----
Hi Jan

your calculation could be set to manual rather than automatic
tools / options / calculation tab

cheers
JulieD




.
Click to expand...
 
Back
Top