Excel like a finance pro.
← The libraryPractice · 2 questions →
Data shortcut
Refresh all data connections and pivot tables
Ctrl + Alt + F5 on Windows, None on Mac.
CommonDifficulty 1050 · Capable
When to use it
Refresh All: updates every pivot table, query, and data connection in the workbook.
The shape of it
- Windows
Ctrl + Alt + F5
- Mac
None
Worked examples
Refresh everything
Press Ctrl + Alt + F5 → All pivots and queries refresh
After updating source data.
One pivot
Alt + F5 → Only the active pivot
Targeted.
Auto refresh
Data, Queries and Connections, Properties, Refresh on open → Automatic refresh
No shortcut needed.
Worth knowing
- Refresh order matters when pivots read query output; Refresh All handles it.
- Slow queries can be set to background refresh.
- Pivots do not update on their own.
Where it goes wrong
- Refreshing external queries needs the source available.
- Long refreshes block the workbook.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.