If you have excel source files and they get updated multiple times per week, what is the best way to continually update this source file so the dashboard leverages the latest data set.
I tried overwriting by saving the file with the same name and this initially worked but has now had issues. The data was not being updated.
The way you describe it should be sufficient.If you replace the Excel file with the same structure but new data you should get the new data into Tableau.
If you use extracts (usually a good thing when connecting to Excel), don't forget to refresh the extract, otherwise the new Excel file won't be read into your Tableau workbook.