Excel 2002 Fill Handle give same answer?

[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

 

[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'

 

[JulieD]

Hi Jan

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

cheers
JulieD

 

[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

 

[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




.

 

[Frank Kabel]

Hi
does hittign CTRL+F) change the entries?

 

[Jan]

Thank you all! (-:

 

[JulieD]

Hi Jan

so what worked?

Cheers
JulieD