View Full Version : Solved: Help:Function not calculate...

03-04-2008, 10:38 AM
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.


Bob Phillips
03-04-2008, 10:57 AM
Goto Tools>Options>View and uncheck the Formulas checkbox in the Window Options section

10-18-2008, 09:21 AM
Thanks XLD