Is there a way I can reuse the worksheet template for forth coming weeks ?
If you mean you have multiple excel files and wish to use the same workbook and point to a new excel file Then it is possible to replace the data source.
See the following online help doc.
Thanks a lot for the input. I understand about the manual selection of Data source.
I was wondering if there is anyway to automate it.
Like, making the tableau point to a particular data source location and fetch the excel file on a regular basis.
Shreenath S R.
Here Iam answering your question the way i understood it.
If you want to automatically update data in tableau server workbook that uses a live connection to a excel file data source. yes you can do that.
1.In Tableau Desktop, select the data source from the Data menu, and select Edit Connection.
2.In the Excel Workbook Connection dialog box, type the full universal naming convention (UNC) path to the Excel data source.
3.For example, D:\datasource.xls has a UNC path that looks like the following: \\workstation1\d$\datasource.xls, where "workstation1" is the full computer name.
4.Select Server > Publish Workbook.
5.In the Publish Workbook to Tableau Server dialog box, uncheck Include External Files.
Click the Publish button.