Excel PivotTable won't refresh — data source reference isn't valid

What this looks like

You click Refresh (or open a workbook that auto-refreshes on load) and instead of updated numbers, Excel shows “The PivotTable field name is not valid” or a flatter “Reference isn't valid.” The pivot table itself is still on the sheet, still showing its last-cached numbers, but Excel won't rebuild it from current data.

Why it happens

A pivot table doesn't store a live link to your data — it stores a fixed reference: a sheet name plus a cell range, or a named range, captured when the pivot was built. That reference breaks in a handful of common ways: the source sheet was renamed or deleted, rows or columns were inserted or removed so the range no longer lines up with the pivot's field list, a header cell in the source range went blank or turned into a duplicate of another header, or the workbook was copied and the source data moved with it while the pivot's reference didn't follow.

What you actually want

To see what the pivot's source range actually is right now, and what data currently lives there, so you can spot the mismatch — not to keep clicking Refresh and reading the same error. xlsx-for-ai reads a pivot table's stored source reference directly from the file, alongside the live data in the workbook, without running Excel's refresh logic — so a broken binding doesn't stop you from seeing the source range, the field layout, or the underlying rows.