VBA for to avoid pressing F2 then Enter

Hi,

I have a formulas in Sheet1 linked to other sheets, but I have only formula and there are no sheets ( eg: in sheet 1 A1 =Data!A1) where as there is no sheet called Data. I have a macro to import this sheets from a different file.

The problem I am facing is, after importing the sheets, the formula still shows #REF but if I do double click the cell or press F2 and then "Enter" the value appears. I have about 1200 formulas in this sheets.

Is ther a way in VBA to do this?

Regards
arvind

I can't parse your question, but perhaps do Find & Replace All = with =