In this article:

How to Refresh a Pivot Table in Google Sheets

May 8, 2024

Use the Refresh key or button

It sometimes takes some time for the new data to be processed and loaded to your Google Sheets Pivot Table in your browser. A simple press on the F5 button of your keyboard or the refresh button in your browser can often work. 

But what if it still doesn’t work? Then it’s time to troubleshoot your Pivot Table. Read on below to discover why your Pivot Table is not refreshing and how to fix it.

Check the range of data

In creating a Pivot Table, you have to specify the range of data. Chances are, the new data are appended as new rows below the existing rows, and thus may not be covered by the range. Here are the steps to check the range of data:

Step 1: Hover your pointer to the Pivot Table.

Step 2: An Edit button will appear below it. Click it. 

Edit button appears after hovering pointer

Step 3: The Pivot table editor sidebar will appear. The data range is shown in the upper portion of the sidebar.

Pivot Table Editor
Opening Pivot Table Editor GIF

How to increase data range

You can adjust the data range in two ways:

Method 1: Add rows to the range. For example:

From A1:H628 to A1:H1000

The disadvantage of this method is that you have to adjust the range again when the number of rows exceeds 1000.

Method 2: Using the same example:

From A1:H628 to A:H

The advantage of this method is that it accounts for additional rows. However, its disadvantage is that extra rows with zero (0) value will appear in the Pivot Table:

Extra rows with zeroes on pivot table

How to Hide Rows:

You can hide them by adding a filter:

Step 1: Scroll down the Pivot table editor sidebar to find the label Filter.

Step 2: Click the Add button, then select the column where you want to apply the filter. For our example, it’s the date column.

Applying a filter to date column
Applying a filter GIF

Step 3: Click the drop-down box. It lists the unique values detected in the selected row. Uncheck (Blanks) and click OK. 

Uncheck blanks
Adding new filter GIF

The blank row has now been cleaned:

New filter removes empty rows

Check Filters

If your data range covers the added rows but they are not added yet to the Pivot Table after refreshing, it is also possible that your current filters have excluded the new rows. To check the rows, simply scroll down the Pivot table editor to find the filters. 

How to adjust the filter to include new rows

Step 1: Click the drop-down box for the filter.

Step 2: Click the unchecked rows. Click Ok.

Editing filter
Editing filter to show new rows in Google Sheets

We hope this article has helped you and given you a better understanding of how to refresh a pivot table in Google Sheets. You might also like our articles on how to make a pivot table in Google Sheets and how to add a calculated field in a pivot table on Google Sheets.

We also recommend reading our guide on how to export email addresses from Google Sheets to optimize your workflow.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->