Google Sheets Pivot Table Not Refreshing? Here’s How To Fix It

Your pivot table in Google Sheets isn’t updating, new data isn’t showing, totals are stale, or changes in the source don’t reflect.
This typically shows up as outdated summaries, missing rows, or incorrect aggregations.

This guide fixes it step by step.

Why the Issue Happens

• Source data range is fixed and doesn’t include new rows
• Pivot table connected to wrong or outdated range
• Filters or slicers blocking new data
• Data format issues (text vs number, invalid dates)
• Hidden rows or filtered data in source
• External data (IMPORTRANGE) not refreshed
• Duplicate or inconsistent headers
• Cache or session lag in browser

Step-by-Step Fixes

Step 1: Check Source Data Range

Pivot tables don’t automatically expand if the range is fixed.

Problem:

A1:D100

New data added after row 100 won’t be included.

Fix:

• Edit pivot table → Data range
• Update to:

A1:D1000

Or use full column (only if optimized):

A:D

Step 2: Reapply or Edit the Data Range

Sometimes the pivot loses connection to updated data.

Fix:

• Click anywhere inside pivot table
• Go to Pivot table editor → Data range
• Re-select the source range manually

This forces refresh.

Step 3: Check for Filters in Pivot

Filters may block new data from appearing.

Fix:

• Open pivot editor
• Check Filters section
• Remove or update filters

Example:

• If filter = “Region = North,” new rows with “South” won’t appear.

Step 4: Ensure Headers Are Clean and Consistent

Pivot tables depend on headers.

Issues:

• Blank headers
• Duplicate column names
• Extra spaces

Fix:

• Ensure first row has unique, clean headers
• Use:

=TRIM(A1)

to clean header text if needed

Step 5: Fix Data Type Issues

Pivot tables won’t aggregate correctly if data types are inconsistent.

Example:

• Numbers stored as text → not summed

Fix:

=VALUE(A2)

Or:

• Format column → Number

Step 6: Refresh External Data (IMPORTRANGE)

If pivot is based on imported data, it may not update instantly.

Fix:

• Re-enter IMPORTRANGE formula
• Or add refresh trigger:

=IMPORTRANGE("FILE_ID","Sheet1!A:D") + NOW()*0

Then refresh pivot.

Step 7: Remove Hidden Rows or Filters in Source

If source data is filtered or hidden:

• Pivot may ignore those rows

Fix:

• Clear filters in source data
• Ensure all rows are visible

Step 8: Avoid Blank Rows in Data

Blank rows can break pivot grouping.

Fix:

=FILTER(A2:D1000, A2:A1000<>"")

Use clean dataset as pivot source.

Step 9: Recreate Pivot Table (If Corrupted)

Sometimes pivot tables glitch.

Fix:

• Delete pivot
• Insert → Pivot table
• Rebuild using same data

This often resolves refresh issues.

Step 10: Check Browser or Session Issues

If everything is correct but pivot still doesn’t update:

Fix:

• Hard refresh:

Ctrl + Shift + R

• Open sheet in Incognito
• Clear browser cache

Common Mistakes

• Using fixed data range that excludes new rows
• Not updating pivot data source
• Ignoring filters in pivot editor
• Having messy or duplicate headers
• Using text-formatted numbers
• Relying on IMPORTRANGE without refresh
• Keeping blank rows in dataset
• Assuming pivot updates automatically in all cases

Pro Tips / Better Alternatives

Use Dynamic Named Ranges

Instead of fixed ranges:

• Define named range that expands automatically
• Use it as pivot source

Improves scalability.

Use QUERY Instead of Pivot (For Dynamic Data)

=QUERY(A1:D1000, "SELECT B, SUM(C) GROUP BY B", 1)

Advantages:

• Auto-updates with new data
• No manual refresh

Combine FILTER + SORT for Lightweight Analysis

=SORT(FILTER(A2:D1000, B2:B1000="Sales"), 3, FALSE)

Faster than pivot for smaller datasets.

Clean Data Before Creating Pivot

Use:

=TRIM()
=CLEAN()
=VALUE()

Clean inputs = reliable pivot output.

Avoid Full Column References in Large Files

Instead of:

A:D

Use:

A1:D1000

Improves performance and refresh speed.

Bottom Line

If your pivot table isn’t refreshing, fix in this order:

1. Update data range to include new rows
2. Reapply or reconnect source data
3. Check and remove filters
4. Fix data types (numbers, dates)
5. Refresh external data sources
6. Clean headers and remove blanks

Most issues come from range limitations and data quality problems.
Fix those, and your pivot table will update reliably.