Getting #REF in data table when data is referred from external sheet
My data table is referring data from another excel file and when i see this data table in Winrunner, I am seeing the value #REF for that parameters.
To make the problem clear:
I have a excel sheet ABC.xls which I use as data table to a script. In ABC.xls, column 1 gets the value from sheet1 of XYZ.xls. If I directly open ABC.xls I am able to see the values correctly as entered in XYZ.xls. But when i try using ABC.xls as a data table and refer the values in the code in Winrunner, it is showing the values as #REF.