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.

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" <(E-Mail Removed)> wrote in message
news:C75E781E-6ECB-461F-8D5A-(E-Mail Removed)...
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.

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.