Just out of interest, is there a reason why you are not using the refreshable web query option? As you have PowerQuery in Excel 2016, you might be able to make this automatic. Do you have a link to the data online?