Excel Pivot table with input from a comma separated value file (both files on SharePoint)

Hello, 

I have an excel file with many pivot tables uploaded on SharePoint. It gets his input data from The CSV file also uploaded on the same share point page. Weekly The CSV file changes (some columns appear, and some disappear).

The comma separated value file  is weekly updated automatically on the SharePoint via Jenkins application. 

The problem is that I don't know how the excel file can take the new info (from the comma separated value file) and refresh all the pivot tables with the new data.

thank you in advance