Excel 2016 – 3.1.11 – Set a PivotTable To Refresh On Open

By default, PivotTables have to be manually Refreshed. However, there is a way that you can set them up to automatically Refresh whenever the Workbook is opened. In this video we’re going to see how you turn on that feature.