Excel Pivot Table Won't Refresh: 5 Fixes That Work

Problem Scenario

You've updated your source data but clicking Refresh on your pivot table doesn't show the new values. The pivot table still displays old cached data.

Solution Steps

1. Check data source range hasn't changed - refresh connection
2. Clear pivot table cache - right-click Refresh
3. Update source data range in PivotTable Options
4. Enable "Refresh data when opening file" option
5. Use VBA to auto-refresh on workbook open

Code Snippet

Private Sub Workbook_Open()
    ActiveWorkbook.RefreshAll
End Sub