Fill handle problem XP
 

From time to time, the fill handle copies the orignal formula but the values
that are filled show the results of the first cell. When you click on the
cells, the correct cell references show in the cell but the result is the
value of the first formula. Any ideas as to what is happening?

Sounds as though the calculation mode is set to manual. You ought to see
the word 'Calculate' in the left portion of the status bar. Fix it by going
to ToolsOptionsCalculation and checking Automatic


"Kylor" wrote in message
...
From time to time, the fill handle copies the orignal formula but the
values
that are filled show the results of the first cell. When you click on
the
cells, the correct cell references show in the cell but the result is the
value of the first formula. Any ideas as to what is happening?

Hi

check tools / options / calculation and ensure it is not set to manual.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Kylor" wrote in message
...
From time to time, the fill handle copies the orignal formula but the
values
that are filled show the results of the first cell. When you click on
the
cells, the correct cell references show in the cell but the result is the
value of the first formula. Any ideas as to what is happening?