Where are the Excel files located ? I'm guessing on a local or network drive.
Did you use a UNC path when connecting to them, or just a Windows drive letter ? I'm guessing Windows drive letter
If using a UNC path, can Tableau Server see the same path ? I'm thinking "no".
For a refresh to work via Tableau Server you must be using UNC paths and Tableau Server must be allowed to access the same UNC path. This is the same for live or refreshing an extract.
files are located on network drive and i am using UNC path. i realized that the datasource connection is automatically pointing to temp directory . why is it repointing to temp directory.
Do you mean for the Excel files ? Tableau does that sometimes (especially when the XLS files are too big), just repoint the files and create the extract again.
Click on edit connection of your data source and open your network path. Here the key is network path. Don't open this using drive.