Excel 2016 Link a text file to a sheet, Pivot Table, Pivot Chart
Link text file data to a sheet and create a Pivot Table and Pivot Chart from the sheet data. When the the text file data is updated the changes are passed through to the sheet, Pivot Table and Pivot Chart