Auto Refresh PivotTables & Queries – without VBA! neha sharma 3 years ago Microsoft Excel Tips and Tricks Auto Refresh PivotTables isn’t on by default, and the process differs depending on whether your data is loaded to the data model or not. Credit MyOnlineTrainingHub