1 Reply Latest reply on Jan 30, 2017 4:32 PM by Jamieson Christian

    manual refresh of datasource not sticking after file is closed/reopened

    David Marcus

      Hi, i have a very simple excel sheet being used as a data source for tableau, which is updated monthly.

       

      once the spreadsheet is updated, I refresh the data source in tableau and the new data shows up.

       

      However, when I close and then reopen tableau the viz has reverted to the old data.

       

      Any advice on how to fix this much appreciated.

       

      using v10.0.0

       

      edit: this is in a twb file, not twbx (thanks Christian)

       

      david M

       

      Message was edited by: David Marcus

        • 1. Re: manual refresh of datasource not sticking after file is closed/reopened
          Jamieson Christian

          David,

           

          Is your workbook a TWB or TWBX (packaged workbook)?

           

          The following applies to TWBX:

           

          In a packaged workbook, the data gets embedded in the workbook when it is saved, and stored in a temporary file when the workbook is opened. If you refresh the extract, it will update the temporary file — but if you don't save the workbook afterwards, the updated extract will not get "re-embedded" into the workbook. Next time you open the workbook, a new temporary file will be created based on what was embedded in the workbook the last time it was saved, so it will appear that the data reverted back.

           

          I hope this shot in the dark helps.