Updating data in pivot table
If you see that message, click OK, then manually refresh the pivot table.
And to avoid the annoying message, turn on the Refresh Data When Opening the File option.
NOTE: This will not work for all pivot tables, but is worth trying, to recover the source data.
Here are 3 ways that you can refresh a pivot table, after you make changes to the source data If you add new records, or delete records, or edit the existing data, the pivot table doesn’t show the revised data right away.
There isn’t any setting the you can change, to make Excel automatically refresh a pivot table.
To try to recreate the source data for a pivot table, follow these steps to use the Show Details feature: If you rename the table that was created during the Show Details process, and use the same name as the table that originally held the source data, the pivot table might automatically connect to the new source data.
If not, you can connect to the recreated source data -- follow the steps in the section above: Use Dynamic Source For Pivot Table -- use the table name that you gave to the new table.