software

Since today I am facing some peculiar change in my excel files. When I
drag a formula from one cell to another cell, result of the first cell
itself are reflected in the subsequent cells. Then I have to press F9
key so that all cells give proper calculation of the formulas.

E.g

ProductPriceQtyValue
A2 10 20
B5 15 20
C10 20 20
D4 2 20
E6 5 20I did the above table in exel. Cell D2 was the result of
multiplication of B2 amp; C2. Thats is correct. The I dragged the formula
from D2 to D6. However in this resultant values in D3, D4, D5, D6
remained same. So I pressed F9 key. After which I got following table
(which is correct).ProductPriceQtyValue
A2 10 20
B5 1575
C10 20200
D4 2 8
E6 5 30What is wrong ? It was working ok till yesterday. This formula drag
error is happening for all calculations. Have I missed something or
some other problem ?????? :Please help me.

Thanks for your time.--
tanksalevikrant
------------------------------------------------------------------------
tanksalevikrant's Profile: www.excelforum.com/member.php...oamp;userid=21786
View this thread: www.excelforum.com/showthread...hreadid=516638Toolsgt;Optionsgt;Calculation tab, check Automatic

--
Kind regards,

Niek Otten

quot;tanksalevikrantquot;
lt;tanksalevikrant.23u7ty_1140958802.4336@excelfor um-nospam.comgt; wrote in
message news:tanksalevikrant.23u7ty_1140958802.4336@excelf orum-nospam.com...
gt;
gt; Since today I am facing some peculiar change in my excel files. When I
gt; drag a formula from one cell to another cell, result of the first cell
gt; itself are reflected in the subsequent cells. Then I have to press F9
gt; key so that all cells give proper calculation of the formulas.
gt;
gt; E.g
gt;
gt; Product Price Qty Value
gt; A 2 10 20
gt; B 5 15 20
gt; C 10 20 20
gt; D 4 2 20
gt; E 6 5 20
gt;
gt;
gt; I did the above table in exel. Cell D2 was the result of
gt; multiplication of B2 amp; C2. Thats is correct. The I dragged the formula
gt; from D2 to D6. However in this resultant values in D3, D4, D5, D6
gt; remained same. So I pressed F9 key. After which I got following table
gt; (which is correct).
gt;
gt;
gt; Product Price Qty Value
gt; A 2 10 20
gt; B 5 15 75
gt; C 10 20 200
gt; D 4 2 8
gt; E 6 5 30
gt;
gt;
gt; What is wrong ? It was working ok till yesterday. This formula drag
gt; error is happening for all calculations. Have I missed something or
gt; some other problem ?????? :Please help me.
gt;
gt; Thanks for your time.
gt;
gt;
gt; --
gt; tanksalevikrant
gt; ------------------------------------------------------------------------
gt; tanksalevikrant's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21786
gt; View this thread: www.excelforum.com/showthread...hreadid=516638
gt;

Thanks you so much,--
tanksalevikrant
------------------------------------------------------------------------
tanksalevikrant's Profile: www.excelforum.com/member.php...oamp;userid=21786
View this thread: www.excelforum.com/showthread...hreadid=516638