How to refresh pivot in Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Steps
-
1
Select the source data including headers.
-
2
Insert → Pivot table.
-
3
Place fields into Rows / Columns / Values.
-
4
Adjust value summarize-by (SUM, COUNTA, etc.).
Related tutorials
These videos might help you go deeper on this topic.
Automatically Clear Content | Refresh Reuse Recycle Templates
Related blog posts
Written guides that go deeper on this question.
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
filters in Google Sheets
Filtering hides rows that do not match criteria without deleting data. The filter toolbar on a header row is the fast...
Open →FILTER
FILTER returns only the rows from a range that meet one or more conditions. Conditions are boolean arrays the same he...
Open →Pivot table
A pivot table summarizes a large table without writing SUMIFS for every combination. Drag fields into rows, columns, ...
Open →CLEAN()
Google Sheets CLEAN() function guide
Open →COLUMNS()
Google Sheets COLUMNS() function guide
Open →COUNTA()
Google Sheets COUNTA() function guide
Open →ROWS()
Google Sheets ROWS() function guide
Open →SUM()
Google Sheets SUM() function guide
Open →Related questions
How to refresh pivot table in Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →How to refresh a pivot table in Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →How to refresh Google Sheets pivot table
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →How to refresh pivot table on Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →How to refresh pivot table Google Sheets
Select your data table, then Insert → Pivot table. Choose New sheet or Existing sheet. Drag fields into Rows, Columns, Values, and Filters in the pivot editor. Refresh by editing the source range; keep headers clean and one row per record.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.