7 Replies Latest reply on Nov 6, 2013 4:14 PM by Shawn Wallwork

    Get data from Excel file named range with formulae

    Focus Media

      Hi all,

       

      I have a named range in a Excel file with this formulae:

       

      =OFFSET(rData!$B$3;0;0;COUNTA(rData!$B:$B)-1;3)

       

      When I try to get data in Tableau, list of selectable options (sheets and named ranges from Excel file) dont show this name!

       

      Its possible to make connection with this named range with formulae?

       

      Txs