...Tables Automatically When Source Data Changes - Excel Campus
Starting from any cell in your pivot table:Go to the Analyze tab in the ribbon. Choose the Options button. Go to the Data tab in the new window that opens. Check the box that says, “Refresh data when opening the file.”Click to Enlarge ...