Forum Discussion

LearningTC's avatar
LearningTC
Occasional Contributor
11 years ago

Data Loop - Not selecting Work sheet from Excel

Hi



In keyword test,i'm trying to make a data loop.

But the Data driven loop wizard is not displaying the excel worksheet.

I've attached the screenshot.

Please advice...

14 Replies

  • Marsha_R's avatar
    Marsha_R
    Icon for Champion Level 3 rankChampion Level 3
    11 years ago
    Perhaps there's a permissions problem with that Excel file.  Try creating a new Excel file on your desktop and see if you can get to that one.
  • LearningTC's avatar
    LearningTC
    Occasional Contributor
    11 years ago
    Marsha,



    Tried it.No use.

    Cant select the worksheet.

    Any other options to try?
  • Marsha_R's avatar
    Marsha_R
    Icon for Champion Level 3 rankChampion Level 3
    11 years ago
    Go back a step, to where you select the Excel workbook.  Does the Edit Workbook button let you open the file?
  • LearningTC's avatar
    LearningTC
    Occasional Contributor
    11 years ago
    yes.I'm able to edit the excel.

    But the next screen doesn't display worksheet.
  • Marsha_R's avatar
    Marsha_R
    Icon for Champion Level 3 rankChampion Level 3
    11 years ago
    Would you post a screenshot of the Excel file with the sheet open?
  • Marsha_R's avatar
    Marsha_R
    Icon for Champion Level 3 rankChampion Level 3
    11 years ago
    Another question instead of an answer  ;)



    Is this an .xlsx file or .xls?  If it's .xlsx, try saving it as .xls then see if that version works.



    If that doesn't work, let's check the version of Excel that you are using.
  • mes6073's avatar
    mes6073
    Contributor
    11 years ago
    Based on the last screen shot, I am going speculate that the OP is working with Excel 2013. For the OP, is it a requirement for this operation to be performed from the UI or can you leverage the Excel Application object to iterate the worksheet colleciton programatically?
    • Alain195's avatar
      Alain195
      New Contributor
      11 years ago

      Hi,

       

      For information, I have exactly the same problem :( and I'm using the Office Professionnel Plus 2010.

      So, there is nothing to do to solve this problem ?

       

      Regards,

      Alain

      • Marsha_R's avatar
        Marsha_R
        Icon for Champion Level 3 rankChampion Level 3
        11 years ago

        Try saving the Excel file as .xls instead of .xlsx - that fixed problems for us.