AutoRefresh in Pivot Table not working in Excel 2016

Hi,   I have 2 sheets in an excel workbook. Sheet 1 gets the data from another workbook using power query which gets refreshed when opening the excel file. Sheet 2 contains an pivot data of Sheet 1...