5 Replies Latest reply on Jan 10, 2019 7:19 AM by Ken Flerlage

    Multiple Sheet Excel Data Source

    John Brown

      I have an excel workbook that has multiple sheets that I have created extracts for.  The excel workbook gets updated from SAS on a daily basis.  Once the excel report is updated, I can only refresh the extract of the first sheet in excel.  Tableau does not recognize the additional sheets, until I open the excel report, make all sheets active, save and close the excel report.  IIs there a way to refresh all the extracts without having to open the excel file first?

       

      Thanks,

       

      John