Thread: 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.

Please help

hi friend..

As per my view just select the excel sheet once again clear the REF problem save it in the exact location and then refer through winrunner

Thanks
deepasree