Author Topic: I am getting "The file you specified is not valid for use with the data table"  (Read 4269 times)

Offline vignesh cb

  • Newbie
  • *
  • Posts: 4
Hi

I am getting "The file you specified is not valid for use with the data table" error while i am associating the data file with QTP.


Steps to get the error message.

1. In QTP, File Menu --> Settings --> Resources Tab --> Other Location (Option Buttton) --> Select
2. Select the Data file ( Excel file)
3. Select Apply Button
4.  Getting the above error message.

Can you please solve this issue and let me know?

Note: the Data file is already closed. Not in open state

Thanks in Advance.

Offline Tarun Lalwani

  • Administrator
  • Hero Member
  • *****
  • Posts: 3025
    • KnowledgeInbox
Are you using xls file or xlsx?
Regards,
Tarun
KnowledgeInbox Administrator

KnowledgeInbox" style="border:0

Offline vignesh cb

  • Newbie
  • *
  • Posts: 4
xls file only.

Offline vignesh cb

  • Newbie
  • *
  • Posts: 4
We are excel 2007 and saving the file in .xls format.
We didnt face this issue, when we are using excel 2002.

Only text in that excel file. no image
« Last Edit: October 21, 2010, 06:26:50 am by vignesh cb »

Offline Tarun Lalwani

  • Administrator
  • Hero Member
  • *****
  • Posts: 3025
    • KnowledgeInbox
Do you have anything special in that file? Images, embedded objects etc...?
Regards,
Tarun
KnowledgeInbox Administrator

KnowledgeInbox" style="border:0

Offline vignesh cb

  • Newbie
  • *
  • Posts: 4
Only text in the excel file.

No image/ or spl characters

Offline dhilip1

  • Newbie
  • *
  • Posts: 1
me too facing same issue withe xcel sheet..

.xls format

Excel 2007

No special values just plain text... Do we have any solution for this issue