I am using keyword driven framework for our application automation using QTP 10.0 in which we are using excel sheet as the input file. I am facing a issue in excel sheet. before making changes in the input sheet i took a back up and then made some changes to create a new one.
But now the problem is the new excel sheet is not working(i mean the flow is not going to the input sheet). But if am replacing the new one with the old one, my scripts are working.
Can someone please suggest, what can be the reason, i made so many changes in the new one, so i want to use the new one.
Re: Not able to use new excel sheet in keyword dri
Does your excel file has data validation (Lists displayed in cells). QTP was programmed to understand excel file in the most basic format. However if the way in which data is stored is complex DataTable.Import statements may fail.