1 of 1 people found this helpful
It sounds like you're saving your workbook as a packaged workbook (twbx), which means Tableau is making a copy of your excel file and putting it into a zip file (which is what a twbx file really is). So when you change the original Excel workbook and save it, it doesn't change the copy in the zip file. Easiest solution is to open the Tableau workbook, save it as an unpackaged workbook (twb). At this point one of two things will happen 1) Tableau will find the original excel file (which now includes the new data) and all is well, or 2) It will ask you for help finding the file (because you changed its location or gave it a different name). Either way you can bring in the new data.
The only reason to save your workbooks as packaged workbooks is to share them with others. Generally speaking always work with unpackaged (twb) workbooks, and then use the File\Export Packaged Workbook option to create the packaged (twbx) to share.
Also, don't forget to SAVE the excel file after you've added the new data (this is the one that always gets me!). Do all this and bringing in the new data is only a F5 keystroke away.
This is why you're the expert. Didn't think about the twb/twbx scenario.