Not sure and I might be wrong, but you may not be able to do that dynamically because we add data to pivot manually in Tableau.
Data typically is not structured like this within the source system. Is it possible that you can go back to the real source of this and use that data instead of what is being provided in Excel?
No, it is not possible.
We do not have access to the source system
The user will need to open the excel and using add-in to refresh the data in the excel
We can only use this excel as data source.