Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula problem
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula problem
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 -- macropod [MVP - Microsoft Word] ------------------------- "Jonathan" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula problem
Have you checked ToolsOptionsCalculation tab, Automatic calculation?
-- Kind regards, Niek Otten Microsoft MVP - Excel "Jonathan" wrote in message ... |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 | |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula problem
Tools/ Options/ Calculation:
Change from Manual to Automatic. -- David Biddulph "Jonathan" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Formula problem | Excel Discussion (Misc queries) | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Now formula problem | Excel Worksheet Functions | |||
Problem with formula IF(C5="", "",NOW()) | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) |