4 Replies Latest reply on Apr 3, 2018 9:18 AM by ShivaRam Chennapragada

    Sheet Swap - Excel Worksheet Data Source

    Teresa Wright

      I have a dashboard where I am "swapping" three worksheets.  The data source is currently an Excel worksheet.  The data set is small (less than 100 rows) and on the 1st of each month the data is updated.  This means the previous months' data is "wiped out" and replaced with new data. 

       

      This is causing issues with my sheet swap dashboard, and essentially I have to almost rebuild the viz each month.  I am a Tableau Desktop user with no access to Server, and I can't use Tableau online for data security reasons 

       

      Is there an easier way to update my monthly data that will not cause issues when I refresh the data in my workbook?

       

      Thanks for any suggestions!