excel function/formula not work normally after exporting/importing data.

[e999]

Hi,


After I input import data from excel to access, or import data from MYOB to excel, excel function/formula not work normally.


I show my problem below.


Suppose:


Cell A1 is 1

Cell B1 is 10

Cell A2 is 2

Cell B2 is 10

Cell A3 is 3

Cell B3 is 10


In cell C1, i type = A1*B1, the result is 10.


Then I copy cell C1, and then paste to cells C2 and C3.

The formula at C2 and C3 are =A2*B2 and A3*B3.

However, the value are still 10 and 10.


The correct value should be 20 and 30.


Any one knows how to solve?


Thanks

 

[Hui]

E999


Firstly, Welcome to the Chandoo.org Forums


You have Calculation Disabled

Goto the Formulas Tab, Calculation options

Set Calculation to Automatic