Once you open your pivot table in your spreadsheet, you should click on the pencil icon that says "Edit", at the bottom of the table.
3
Then, go to "select data range".
4
You can refresh you pivot table by editing and/or selecting your preferred data range. In this case, I'm sticking to the suggested data range.
5
Then, you should click on "OK". That's all!
Tip! You can also refresh it through keyboard shortcuts.
- If you have a Mac, you should press "command+shift+F5"
- If you are working on a Windows/Linux, you should press "Ctrl+shift+F5".