How to Update and Refresh a Pivot Table in Google Sheets

To update a pivot table in Google Sheets, change the source data and the pivot table will usually recalculate automatically. If you add rows or columns beyond the original source range, click inside the pivot table, edit the data range in the Pivot table editor, and then adjust its rows, columns, values, or filters as needed. Google Sheets does not have a general-purpose Refresh button for standard pivot tables.

What You’ll Need

A Google Sheets file containing an existing pivot table and the source data it summarizes.
Permission to edit the spreadsheet. If you can only view it, ask the owner for editing access or a copy you can change.
Well-organized source data: one header row, one record per row, and consistent columns without merged cells or blank header names.

Before making changes, note where the source data is stored and which fields the pivot table currently uses. If the report is important, make a copy of the spreadsheet first so you can compare the original setup if needed.

Step-by-Step

Open the pivot table and its editor. Find the sheet containing the summary, then click any cell inside the pivot table. The Pivot table editor should open in a panel on the right. If it does not appear, double-click a pivot-table cell or right-click one and look for an option to edit the pivot table. Clicking a cell outside the pivot table will not open its settings.
Check the current source range. At the top of the Pivot table editor, review the data range. It identifies the cells the pivot table reads, including the header row. For example, a range might be Sales Data!A1:E500. Confirm that the sheet name and columns match the records you intend to summarize. If your sheet name contains spaces, Sheets may display it with single quotation marks, such as 'Sales Data'!A1:E500.
Expand the range if you added records outside it. If the original range ends at row 500 and you have added records below that row, update the range to include those rows. Click the range field and enter the expanded range, or use its range-selection control to select the cells on the sheet. Include the header row and every source column used by the pivot. For instance, change the ending row from 500 to 800 if the new records extend through row 800, then confirm the selection.
Include new columns when the source structure changes. If you have added a field such as Region or Sales Channel in column F, extend the source range to include column F as well as the new records. The new field should have a clear header in the header row. After changing the range, look in the editor for the newly available field. If the field does not appear, check that the range includes its header cell and that the header is not blank.
Choose the fields to organize the summary. In the editor, use Add beside Rows or Columns to choose a field. Rows list categories down the side of the pivot table; Columns split the results across the top. For example, add Product to Rows and Month to Columns to compare products across months. Use the field’s options to control sorting and, where available, how values are grouped. Remove a field with its remove control if it is no longer useful.
Set or revise the values being calculated. Use Add beside Values and select the numeric field you want to summarize, such as Units Sold or Revenue. Open that value’s summary setting and choose the appropriate calculation, such as SUM, AVERAGE, or COUNT, when available. Check that the selected calculation matches the question you are answering: adding revenue is different from counting transactions. You can add more than one value field to display multiple measures.
Adjust filters to include the records you want. Use Add beside Filters to select a field, then choose which values to show or exclude. A filter can help focus a report on one region or period, but it can also make a complete dataset look incomplete. Review any existing filters after changing the source range, especially if the new records contain categories that were not present before. Clear or revise a filter if the new categories should be included.
Review the updated result. Check the pivot table for the expected labels, totals, and date periods. Compare a small sample with the source data, and confirm that new records appear in the relevant row or column. If the report looks right, click outside the pivot table editor. Changes are saved in the spreadsheet automatically; you do not need to export or manually save the pivot table.
Keep future additions in mind. If you often append records, make the source range large enough to cover expected additions, or use a whole-column range such as 'Sales Data'!A:F if the data has headers in row 1 and those columns contain only the intended source fields. A bounded range can be easier to audit, while a larger range reduces the chance that new rows are left out. Make sure extra columns do not contain unrelated data that would confuse the pivot setup.

Common Mistakes

Adding rows but not extending the source range. A pivot table can only summarize cells inside its selected range. Records pasted below the range will not be included just because they are on the same sheet. Update the range and verify the last row is covered.
Leaving out the header row or using an empty header. The pivot editor relies on column headings to identify fields. Include the header row in the range, use a unique, descriptive heading for every column, and avoid merged header cells. If two columns have identical names, rename them so you can tell their fields apart.
Choosing the wrong summary calculation. Counting entries can be useful for a transaction total, but it is not the same as summing a quantity or amount. Check the value field’s summary setting and confirm the source values are recognized as numbers where a numeric total is expected.
Assuming every missing result is a refresh problem. A filter may be excluding a category, a date may be grouped differently than expected, or a source cell may be blank. Inspect the field settings and the original records before rebuilding the pivot table.
Editing the pivot output as if it were ordinary data. The pivot table is generated from its source and configuration. Typing into a result cell can be blocked or overwritten by the pivot output. Change the source records or editor settings instead.

Tips

Keep the source data in a single rectangular table: one row per record and one column per attribute. Avoid totals rows inside the data range, since they can be treated as additional records and inflate your result.
Use stable, clear field names such as Order Date, Region, and Net Sales. Consistent headers make the editor easier to use and make it simpler to spot a missing field after you expand the range.
When appending records, paste values into the existing columns and retain the same data types. Dates stored as text or numbers stored with stray text can behave unexpectedly when grouped or summarized.
Keep the source and pivot table on clearly named sheets, such as Raw Data and Monthly Summary. This makes it easier to confirm the correct source range and helps other editors understand where to make changes.
If the pivot table is used for regular reporting, document its source range and purpose in a nearby note. A short note such as Updated from Raw Data through the latest import can make routine checks quicker without changing the pivot itself.

Troubleshooting

New rows are missing: Click the pivot table and inspect the range at the top of the editor. Extend its ending row to cover the added records. Check that the new records are under the right headers, contain values in the fields used by the pivot, and have not been pasted into a different sheet. Then inspect filters to ensure the new categories are not excluded.

A new field is not available: Confirm that the source range includes the column and its header cell. Give the header a name, avoid merged cells, and make sure it is in the same header row as the other fields. Click away and back into the pivot table if the editor has not visibly updated, then check the available fields again.

The pivot table appears unchanged after editing source cells: First confirm that you edited a cell inside the source range, not a similar-looking table elsewhere. Wait briefly for the sheet to recalculate, then click a pivot cell and verify the range and filters. If the display still seems stale, reload the browser tab after confirming that your edits have been saved. A reload cannot fix an incorrect range, so check that before relying on it.

Totals are blank or incorrect: Check whether the source cells contain numbers or dates in a consistent format rather than text, blanks, or error values. Confirm that the value field is set to the intended summary calculation. For a sum, verify that the source column contains numeric values; changing a text-formatted value into a number may be necessary before the pivot can total it correctly.

Dates or categories look grouped unexpectedly: Review the row or column field settings and any grouping choices, then inspect the original values for inconsistent formats. For example, a date stored as text may not behave like a true date. Correct the source values consistently and review the pivot settings again.

The Pivot table editor will not open or changes are blocked: Make sure you are selecting a cell inside the actual pivot output and that you have edit permission. If the sheet or range is protected, ask the owner to grant access or remove the relevant protection. You can also try opening the spreadsheet in a current browser tab rather than a read-only preview.

Frequently Asked Questions

Does a Google Sheets pivot table update automatically?
For changes made within its existing source range, a standard pivot table generally recalculates automatically. If new records are outside that range, expand the range in the Pivot table editor. There is no standard Refresh button that replaces checking the source range and settings.

How do I add new rows to an existing pivot table?
Click a pivot-table cell, edit the source range at the top of the Pivot table editor, and extend it to include the new rows. Keep the original header row in the range, then check the pivot output and its filters.

Can I update a pivot table without rebuilding it?
Yes. You can change its range and revise Rows, Columns, Values, and Filters in the editor. Rebuilding is usually unnecessary unless you want a different pivot table from scratch or the existing setup is damaged.

Why does my pivot table show an old total?
The edited records may be outside the range, excluded by a filter, or stored in a format that prevents the intended calculation. Check the range first, then inspect filters and the source values. Allow a moment for recalculation before deciding the table is stuck.

Can I update a Google Sheets pivot table in the mobile app?
Viewing pivot results is possible on mobile, but editing the pivot configuration is more straightforward in Google Sheets in a desktop web browser. Use the browser-based editor for range changes and detailed field settings.

Will changing the source data change my pivot table layout?
Changing values usually changes the summarized results, not the layout you configured. Adding a new source column makes another field available, but it will not necessarily appear in the report until you add it under Rows, Columns, Values, or Filters.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.