Wednesday, May 20, 2009

QTP issue 'Sheet already in use'.

I came up with this unique issue wherein i was receiving this 'Sheet already in use error popup when i was trying to execute my QTP scripts. The QTP scripts were upgraded from 9.2 to 10.0 wherein we had lost the association between External Reusable Actions and the main script which used to call those reusable actions. The Default.xls did not loose Data Tables for the called Reusable actions. We could not help but delete those additional sheets from Default.xls and only then the scripts started running fine. Now even today i still doubt about the upgrade issues we have faced during upgrading QTP from 9.2 to 10.0. I can list atleast 10 issues here and still many to foloow i guess.
But sometimes i feel it was good that we had issues... I get paid for resolving it :)

2 comments:

Anonymous said...

eBook for learning Software Testing And QTP

Unknown said...

The order of you sheets in your external Excel need to have same order as the Actions. If you have Action1 and Action2 and your sheet order is Action2 and Action1, it will produce this error.

Just reverse the order of your sheets to Action1 and Action2 will fix it.