Importing Excel sheet with Reference Values

[sukhdeepsinghkohli]

Hi

I am trying to import a Excel sheet which has Column value as a Reference of another sheet.

However, when it is imported into QTP it does'nt pick up the values and gives #REF!

Any way to overcome the problem ?

[Anand]

It will be better that you read the Reference Value of another sheet using second loop.