How to Fix a Google Sheets Pivot Table That Is Not Updating

To refresh an ordinary pivot table in Google Sheets, update its source cells; if new records are missing, expand its source range and update its filters. Sheets automatically refreshes ordinary pivots when their source cells change. Connected Sheets pivots have separate Refresh controls for their connected data.

Start with the source range and filters before changing browser settings or rebuilding the pivot. Open the spreadsheet on a computer so you can use the pivot editor and connected refresh controls.

Correct the cells feeding the pivot

Open the source data and inspect a record whose updated value should appear in the pivot. Correct that source cell, then check the pivot output. For an ordinary range-based pivot, changing a cell inside its source range triggers the automatic update.

If the source cell still contains an old formula result or an import error, fix that input before changing the pivot configuration. The pivot cannot summarize a new value until its source contains it. When the source already shows the correct data, check whether the pivot’s selected range includes it.

Expand the source range to include new data

Click Edit underneath the pivot table, then click Select data range in the side panel. Adjust the range to include the header row, every new record, and any new columns. A pivot using Data!A1:E100 excludes records beyond row 100.

Check the range boundaries after changing the source layout. If you insert multiple rows in Sheets, confirm those records fall inside the selected range. After you add columns in Google Sheets, include the new fields too.

For a source that regularly gains rows, use Select data range to replace a fixed range such as Data!A1:E100 with Data!A:E. This open-ended range includes all rows in columns A through E, so keep the pivot output outside those source columns or on another sheet. Open-ended ranges reduce range maintenance but can increase calculation work.

Keep the actual column headers inside the selection. If you rename columns in Google Sheets, include the revised header row when checking the source range. If the range contains all the intended data but records remain missing, check the filters next.

Update filters that hide new records

A saved value filter can exclude new categories even after the source range includes them. Click Edit, then under Filters, open the affected field’s dropdown. An unrestricted dropdown is labeled Showing all items.

Under Filter by values, update the visible-value list to include the new source values, then click OK. Google says saved filter lists must be updated to show new values. Expanding the source range alone does not update that saved selection.

To check whether a filter is hiding records, click Remove for the restrictive field under Filters. Inspect the pivot, then reapply the filter with the intended selections. Alternatively, open the field’s dropdown, choose Filter by condition, configure a condition that admits the records you want, and click OK.

A slicer can also restrict the dataset shown in the pivot. Click the slicer, then choose Menu > Delete slicer to remove it. Removing it also changes the filtering of other charts and pivots using that dataset on the same sheet, so check which results it controls first.

Calculate stale source formulas

When formulas feed the pivot, inspect their results before making more pivot changes. If manual calculation is active, click Calculate at the top of the spreadsheet. This runs the calculations needed to update the pivot’s source values.

To restore automatic calculation, open File > Settings > Calculation. Under Calculation Mode, select Automatic mode, then click Save settings. You need editing permission to change this setting; if these controls do not appear, continue with the formula and import checks.

For a slow, formula-heavy source, replace unnecessarily large formula references with bounded ranges that still include every required record. Shorten long dependency chains and reference one shared volatile-function result where practical. These changes reduce source calculation work, which must finish before the pivot can reflect its results.

Refresh imported data before the pivot

If IMPORTDATA, IMPORTHTML, or IMPORTXML supplies the source cells, overwrite the import cell with the same formula to trigger an import refresh. These functions also check for updates hourly while the spreadsheet remains open. Reloading or reopening the spreadsheet does not trigger an import refresh.

If an external-data warning blocks the import, open the spreadsheet in a desktop browser with editing access and click Allow access in the banner. For repeated loading or throttling problems, reduce repeated import calls and frequent changes to their source arguments. If IMPORTXML shows Result too large, narrow the XPath query; if an error says your administrator has blocked imports from the source, ask the administrator to allow it.

Import formulas also cannot depend directly or indirectly on NOW, RAND, or RANDBETWEEN. Remove those dependencies, or copy the volatile result and choose Paste special > Values only when a fixed value is suitable. Reference that static value afterward, remembering that it will no longer change automatically.

For IMPORTRANGE, overwrite its cell with the same formula and check that its range_string includes the new rows or columns. Allow calculations in the original spreadsheet to finish. At an initial #REF! connection prompt, click Allow Access; if you lack permission, open the source spreadsheet, request access, and wait for its owner to grant it.

Persistent IMPORTRANGE delays can come from chains of receiving spreadsheets, circular imports, or large imported ranges. Shorten the chain, remove circular imports, and import a smaller range. Where possible, aggregate the data in the original spreadsheet before importing it to reduce the amount transferred.

Refresh connected data and repair connection errors

For a BigQuery-connected pivot, click Refresh at the bottom of the pivot table. To update selected connected objects or all connected data, open More > Refresh options beside Refresh. Select the items to refresh or click Refresh all.

For Looker-connected pivots, open More > Refresh options beside Refresh. Select the objects you want to update or click Refresh all. If you changed the pivot’s fields through Edit, click Apply; to remove a restrictive filter, click Remove under Filters, then click Apply.

If a BigQuery error identifies a deleted source table, open More options > Connection settings beside Refresh, select the replacement table, and click Connect. Correct changed column references when the source schema has changed. If job access fails, change the billing project or request access from its owner.

If a Looker pivot needs a different source Explore, click Connection settings at the top right, select the new Explore, and click Connect. If records remain excluded, inspect Looker filters for restrictions defined in the underlying model. Resolve the connection or filter issue before refreshing again.

Reload Sheets and check the browser

When the source and pivot settings are correct but the editor seems stuck, click your browser’s Reload control. In Chrome on Windows or Linux, you can press F5 or Ctrl + R. If Sheets reports a temporary server or editing error, Google recommends waiting five minutes before reloading.

To reload Chrome while bypassing cached page content, press Ctrl + Shift + R on Windows or Linux, or Command + Shift + R on Mac. This addresses browser loading problems; it does not expand the pivot’s source range or fetch fresh data for IMPORTDATA, IMPORTHTML, or IMPORTXML.

Next, choose More > New Incognito window in Chrome, sign in to the Google Account with access, and open the spreadsheet. Extensions explicitly allowed in Incognito can still run. If the spreadsheet works there, open More > Extensions > Manage extensions in your regular window, turn extensions off one at a time, and reopen the spreadsheet after each change to identify interference.

For persistent loading or session problems, open More > Delete browsing data and choose the relevant time range. Select Cookies and other site data and check Cached images and files, then click Delete data. Reopen Sheets and sign in again if required.

If the editor still fails to load correctly, open the same spreadsheet in another supported browser or on another computer. If your connection is unreliable, try a more reliable network or a wired connection where available.

Reset or recreate the pivot

After correcting the source range, filters, and source formulas, reset the pivot if its configuration still needs rebuilding. Click Edit > Clear all, then rebuild Rows, Columns, and Values using Add. This clears the configuration, so be ready to recreate the fields you need.

Alternatively, select the complete source data, including headers, and choose Insert > Pivot table to create a replacement. Rebuilding cannot repair stale source formulas or missing imported data, so check those inputs first.

If the file itself continues to have editor problems, open Google Drive, right-click the spreadsheet, and click Make a copy. Open the copy and check the pivot and its sources. The copy does not retain the original version history.

Frequently Asked Questions

Can you refresh or edit a pivot table in the Google Sheets mobile app?

Google directs pivot-table work to a computer. You also need a computer to create, edit, or refresh Connected Sheets data, and manual calculation is unavailable in the mobile app.

Will converting the source data into a Sheets table automatically expand the pivot source?

Pivot tables do not support table references when selecting a source range. You still need an appropriate A1 range for the pivot, even if you format the source as a Sheets table.

Can grouped items make updated pivot data look missing?

Yes, grouping can conceal individual items even when the source has updated. Right-click a grouped pivot item and click Ungroup pivot items, then inspect the individual records before deciding whether to regroup them.

Can Google Sheets refresh connected pivots on a schedule?

Yes, you can schedule refreshes for BigQuery and Looker connections. Beside Refresh, open More > Refresh options, then under Scheduled refresh, click Setup now, choose the frequency, and click Save. Scheduled refreshes run as their owner and exclude preview and failed objects.

Can Apps Script force an ordinary pivot table to refresh?

Google does not provide a refresh() method for ordinary pivot tables. You can use DataSourcePivotTable.refreshData() for database-connected pivots with the required authorization and permissions. Calling SpreadsheetApp.flush() applies pending spreadsheet changes but is not a universal pivot-refresh or external-data-fetch command.