formula problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan - 31 Aug 2007 10:20 GMT

I have a big excel file(300m). When I analyse the data on the sheet, say, for
example, give cell D2 the value of C2, then insert a formula =D2+1 for D3,
then dragging the D column for the same formula. But the strange thing is
that the cells that I thave dragged have the same value, not the sequence
with 1 added. however , the formula is always right for each cell but still
returns the same value.

When i do it one by one by hand, it returns the right answer

very odd situation, and hopes for any help

Thx

Reply to this Message

macropod - 31 Aug 2007 10:33 GMT

Hi Jonathan,

Sounds like someone has turned off the automatic re-calc (Tools|Options|Calculation). If you want to keep it that way, pressing F9
will force a recalc.

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

>I have a big excel file(300m). When I analyse the data on the sheet, say, for
> example, give cell D2 the value of C2, then insert a formula =D2+1 for D3,
[quoted text clipped - 8 lines]
>
> Thx

Reply to this Message

Niek Otten - 31 Aug 2007 10:36 GMT

Have you checked Tools>Options>Calculation tab, Automatic calculation?

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a big excel file(300m). When I analyse the data on the sheet, say, for
| example, give cell D2 the value of C2, then insert a formula =D2+1 for D3,
[quoted text clipped - 8 lines]
|
| Thx

Reply to this Message

David Biddulph - 31 Aug 2007 10:50 GMT

Tools/ Options/ Calculation:
Change from Manual to Automatic.

Signature

David Biddulph

>I have a big excel file(300m). When I analyse the data on the sheet, say,
>for
[quoted text clipped - 10 lines]
>
> Thx

Reply to this Message