1 2 Previous Next 22 Replies Latest reply on Mar 24, 2020 11:46 AM by Ken Flerlage

    Tableau Prep Only Recognizing One (Left-Most) of Two Worksheets in "Read-Only" Excel Data Source

    Ryan Calovich

      Hey everyone.

       

      Within Tableau Prep, I'm connecting an excel workbook (with two tabs) as a data source connection. The excel file is Read-Only, and (I think) because of this, Tableau Prep only recognizes the left-most worksheet from Excel. Is there a way around this?

       

      When I save the excel workbook, than Tableau Prep recognizes the other tab. But, this isn't a realistic solution for my problem because I have excel's being created every day - and then I just union them in Tableau Prep.

       

      (tableau prep version, 2020.1.3)

       

      EDIT: This same behavior happens on Tableau Desktop (2019.3.0) too

        1 2 Previous Next