Excel 2002 Fill Handle give same answer?

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
 
F

Frank Kabel

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

JulieD

Hi Jan

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

cheers
JulieD
 
B

Bernie Deitrick

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
 
J

Jan

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