Tableau Server's services typically run using a "Run As" account, which tends to be an Active Directory account. You'll need to make sure that that AD account has access to the folder and the file where the Excel file is stored. Here's a detailed discussion of this topic which may be helpful: auto refresh of excel data source in tableau server
Hi, just following up to see if we have adequately addressed your question. If so, could you please mark one of the responses as the correct answer? If not, please let us know how else we can help. Thanks!