Can you change the function of the fill handle on a cell in Excel
 

I have a problem when dragging formulas across. Every cell is holding the
figure from that of the one i am dragging from but when you look at the cell
it says it is adding up the correct cells. When you double click on that
cell then it amends the figure to be correct.

Can you change the function of the fill handle on a cell in Excel
 

Check to see that your calc mode is set to auto:

<Tools <Options <Calculation tab,
And make sure "Automatic" *is checked*.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"AndreaRaRa" wrote in message
...
I have a problem when dragging formulas across. Every cell is holding the
figure from that of the one i am dragging from but when you look at the cell
it says it is adding up the correct cells. When you double click on that
cell then it amends the figure to be correct.

Can you change the function of the fill handle on a cell in Excel
 

Have you perhaps turned off auto-calculation? (Tools / Options, on the
Calculation tab). You could either set this to Automatic or, when you need
calcs updated, hit function key F9.

"AndreaRaRa" wrote:

I have a problem when dragging formulas across. Every cell is holding the
figure from that of the one i am dragging from but when you look at the cell
it says it is adding up the correct cells. When you double click on that
cell then it amends the figure to be correct.