Auto refresh is getting failes when the data source is MS Excel. Any help on this?
make sure of two things:
1. The Tableau Server runas account has access to the location of your Excel
2. Try using the UNC path instead of a drive letter. How to set UNC path for Excel Based Extract?
As a supplementary to Jeff's advice, two KB links for your reference.
Automatically Updating Data in a Tableau Server Workbook That Uses a Live Connection to Excel | Tableau Software
Unable to Update the UNC Path for a Published Excel Data Connection | Tableau Software
Retrieving data ...