Excel formulas imported from tab-delimited files

[Nimmi Srivastav]

I am trying to import some tab delimited entries into an Excel
spreadsheet. Everything is working fine and dandy except that the
formula fields which reference other worksheets in the spreadsheet are
not getting automatically resolved unless I double click on them. For
example, the "=Employee_Info!Y6" entry is not automatically getting
resolved unless I double click on that value. Formulas that do not
reference other worksheets are resolving correctly, without any
intervention.

Can someone kindly suggest how I can get past the problem?

Thanks,
Nimmi

 

[Dave Peterson]

I'm not sure why excel isn't seeing them as formulas, but

You can select a single cell
edit|Replace
what: = (equal sign)
with: = (equal sign)
replace all

Maybe excel will see your entries as formulas.