...
b. If you are connecting to data that are in EXCEL files on the BOX drive, where the EXCEL files are being updated via automated reports, then there is an additional step involved. In this case, you have to extract your data, else you cannot publish your file to the server.
Extracting Data for Tableau Server Files
...