From the course: Excel PivotTable Quick Tips
Join today to access over 25,500 courses taught by industry experts.
Refresh a PivotTable - Microsoft Excel Tutorial
From the course: Excel PivotTable Quick Tips
Refresh a PivotTable
- [Narrator] If any of your source data changes, in this case, it's from the order sheet, even if it's in an Excel table, you need to refresh the PivotTable. Change to the PivotTable Analyze tab and click Refresh. You can also press Alt + F5 on your keyboard. If you want the PivotTable to automatically refresh every time you open up the workbook, still on the same tab, all the way on the left-hand side, click Options. Change to the Data tab and place a check mark next to Refresh data when opening the file.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.