Solved: Help:Function not calculate...

[yurble_vn]

Dear All,

Please help in this case.

As attached file, I have this file created in other computer. What happen is that: the function is just display as text and did not update anything. I firstly though of excel installation. BUt after copied this file to my PC, it still not works?

Another error I'm facing is that: When I'm inputing function where I need to input the value by selecting cells from other workbooks. Excel escape out of the inputing function???

For example, I'm working on workbookA, Sheet 1, and typing the function:
=match(A1, )
Then I click on workbookB to select the column A1:A20 of this workbook as the input array for the above function. Then Excel escape totally out of match function????

Thanks in advance.

Regards,

[Bob Phillips]

Goto Tools>Options>View and uncheck the Formulas checkbox in the Window Options section

[yurble_vn]

Thanks XLD