How to Update Pivot Table Data in Google Sheets

Google Sheets pivot tables update automatically when cells in their source range change. If you add rows or columns outside that range, click the pivot table, open its editor, and expand the Data range to include the new data; then review the pivot fields and results.

How pivot table updates work

A pivot table summarizes the records in a selected source range. It does not usually store a separate, frozen copy that you must refresh by hand: edits to source values within the selected range are reflected in the pivot table automatically. For example, if a sales amount changes in a row already covered by the source range, the total for that product or region should recalculate.

The range is the important boundary. If the pivot table uses A1:D500, changes in rows 1 through 500 are covered, but a newly pasted record in row 501 is not included. The pivot table can appear stale even though it is behaving as configured. Similarly, adding a field in column E will not make that field available to the pivot editor until the source range includes column E.

There is no need to treat an ordinary Google Sheets pivot table like an Excel pivot table that requires a manual Refresh command. Google Sheets generally recalculates it from its source as data changes. The common fix is to correct the source range, not to look for a refresh button.

Check the current source range

Start by selecting any cell inside the pivot table. Google Sheets opens the Pivot table editor in a panel on the right. Look near the top of that panel for Data range. The range shown there tells you which rows and columns the pivot table currently reads. If the editor is not visible, click inside the pivot table again; selecting a cell elsewhere in the sheet closes or changes the available editing controls.

Compare that range with the actual source data. Check that it includes the header row and every populated row and column you intend to summarize. A source range such as A1:D500 includes four columns and up to row 500. If the source data is on another sheet, its range will also identify that sheet. Confirm that the pivot table is connected to the intended tab rather than a similarly named older or staging tab.

If the newest records are below the ending row, extend the row boundary.
If a new category or measure is in a column to the right, extend the column boundary.
If the range points to the wrong tab or starts below the headers, select the correct range before changing the pivot layout.

Expand or change the data range

To include records that were added after the pivot table was created, click the pivot table and use the Pivot table editor. Next to Data range, click the range selector, select or enter the full source range, and confirm it. For example, if the existing source is Sales!A1:D500 and new records now run through row 650, change it to Sales!A1:D650. The exact sheet name and row numbers will depend on your file. Once the range is accepted, check the pivot results and editor fields.

To include a newly added column, expand the right edge as well. For instance, change Sales!A1:D650 to Sales!A1:E650 if column E contains a field you want to use. Including the column makes its header available as a field; it does not automatically add that field to Rows, Columns, Values, or Filters. Add it in the Pivot table editor where appropriate.

You can select the cells directly or type a range into the range selector. Keep the header row at the top of the selected range, and make sure each source column has a descriptive header. After changing the range, check for unexpected blank rows, incorrect totals, or fields that are missing because the range still excludes them.

Include future rows without editing the range each time

If new records are regularly appended, you can choose a source range that leaves room for them. For example, a range covering columns A through D can include future entries in those columns, provided the headers are in the first row and the new records are entered within the selected columns. A broader range reduces the chance that the pivot table will omit the next batch of records.

There is a trade-off: an unnecessarily broad source can include stray notes, extra headers, or blank records that complicate the pivot table. A blank value in a field may appear as a blank category, and unrelated content in the selected columns can be treated as source data. Keep the source area organized, with one header row and one record per row, rather than placing notes or totals underneath the records.

Another practical option is to reserve a generous number of rows in the source range and periodically check that the pivot still covers the latest record. Choose a range based on how the sheet is maintained, not simply the largest range possible. If the source is a frequently changing export, confirm after each replacement that the export has not moved columns or changed its headers.

Update the pivot table layout after adding data

Changing the range brings additional source records into the pivot table, but it does not decide how to summarize them. Use the Pivot table editor to add or adjust fields under Rows, Columns, Values, and Filters. Rows and Columns create groupings; Values performs a summary such as a sum or count; Filters limit which source records contribute to the displayed result.

For example, imagine a source sheet with Date, Region, Product, and Sales columns. Expanding the range to include new sales rows updates the available records, while the existing pivot might still show sales by Region. To compare products as well, add Product under Columns or Rows. To show the number of sales records rather than their dollar total, adjust the summary for the relevant Values field. Verify that the chosen summary makes sense for the data: summing sales amounts is different from counting records.

If you add a new source field, such as Salesperson, it will appear as a field after the data range includes its column. Drag or add it to the desired section in the editor. A new field will not necessarily appear in the displayed table until you place it in the layout. Likewise, removing a field from the pivot layout does not delete the corresponding source column; it only changes the summary.

Common problems and how to fix them

New rows do not appear: Check whether the appended rows are below the range’s last row. Expand the range to include them, then inspect the total and any row labels.
A new field is missing: Make sure the source range extends through that column and that the column has a header. Then look for the field in the editor.
The pivot shows blank labels: Check the source column for empty cells and check whether the selected range includes unused rows. Fill or remove unintended blanks in the source if they should not be represented.
Totals look too high: Confirm that the source does not contain duplicated records or repeated header rows. Pivot tables summarize the rows they receive; they do not automatically know that two similar records are duplicates.
Values are counted instead of summed: In the Values section, review the field’s summary setting. Also check that the source values are numeric rather than numbers stored as text or mixed with labels.
Fields or results changed unexpectedly: Review the source headers and range boundaries. Renaming headers, inserting a second header row, or including a nearby notes column can alter what the pivot editor reads.

When diagnosing a surprising result, compare a small sample of source rows with the corresponding pivot category. Confirm the source range first, then verify the field placement and summary setting. This order helps distinguish a missing-data problem from a layout or aggregation problem.

Keep the source data pivot-friendly

A reliable pivot table starts with a tidy source table. Use one header row, keep each record on one row, and put one type of information in each column. Avoid merged cells, subtotals inserted between records, and blank separator rows in the middle of the dataset. These conventions make it easier for Sheets to identify fields consistently and for you to expand the range later.

Consider a simple example: a sales log with Date, Region, Product, and Sales as its four headers. Each following row should describe one sale, with the date in the Date column and the amount in Sales. Do not add a subtotal row after each region inside the source list; the pivot table itself can group and total the records. If the source comes from an export, preserve its header row and check that each refresh of the export keeps the same column order.

Before sharing or relying on a summary, check that the pivot includes the latest source row and that its grand total agrees with a reasonable check of the underlying data. A pivot table is a summary tool, not a guarantee that the source records are complete or correct.

Google Sheets and Excel refresh behavior

Excel users may expect a command such as Refresh or Refresh All. Google Sheets pivot tables work differently for ordinary spreadsheet ranges: changes within the selected source range are normally reflected automatically. If data is missing, first verify the range and the source itself rather than assuming that a manual refresh is required. Excel menu paths and refresh controls do not apply to Google Sheets.

Google Sheets is browser-based, so the Pivot table editor and its controls appear in the sheet interface rather than on an Excel ribbon. If collaborators are editing the same file, allow their changes to appear and then recheck the source range and pivot output. For a pivot based on an unusual external or connected data source, update behavior can depend on that source; consult the controls available for that connector instead of assuming it behaves exactly like a normal cell range.

Frequently Asked Questions

Do Google Sheets pivot tables update automatically?
Yes, edits within the pivot table’s source range are generally reflected automatically. New rows or columns outside that range must be included by changing Data range in the Pivot table editor.

How do I add new rows to a pivot table in Google Sheets?
Select the pivot table, open its editor, click the range selector beside Data range, and extend the selected range to cover the new rows. Confirm the range and check that the new records appear in the expected categories.

Is there a refresh button for pivot tables in Google Sheets?
For a standard pivot table built from cells in the spreadsheet, you normally do not need a manual refresh button. The table responds to source changes within its range. If results seem stale, check the range and source data first.

Why is my new column not showing in the pivot table editor?
The column may be outside the current source range, or it may not have a header. Expand Data range to include the column and ensure its first-row header is present; then look for the field in the editor.

Can I make a pivot table include future rows automatically?
You can set a range that leaves room for additional rows, as long as the added records stay within the selected columns and range. Keep that source area clean so notes, repeated headers, and unrelated content are not included in the summary.

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.