I am in the same quandary, How can I use an Excel(changing data) as a data source with Tableau Server
We have the same problem on our side!
Anyone has an idea on how to have a workbook on Tableau Server that has a live connection to an Excel file stored on a network drive (and of course later changes in the Excel file are reflected in the workbook) ?
Can you use an extract and have the extract refreshed by the scheduler on Tableau Server? That's how we update ours. Of course, we only need a weekly update, not a consistent one.