I am using Excel 2002 to link two workbooks. In destination, I got the
formulas instead of values for all columns pointing to constants (text
format), and values for other columns pointing to cells containing numbers.
All of them are linked to the same workbook in the exactly same way. And I
have tried Ctrl+`, but it only widen the columns for me (I do not know why).

Could any guru please help for this?