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?
|