Start Pivot table not updating data updated

Pivot table not updating data updated

To fix this, you can change an Excel setting, so the Get Pivot Data formula doesn’t appear automatically.

If you try to link to a value cell in a pivot table, a Get Pivot Data formula appears, instead of a simple link.

This is a very useful function, but you might prefer to have a simple link most of the time.

I made a list of my top 5 annoyances, and you might have other problems to add to the list.

If you remove or change data in the pivot table’s source, then refresh the pivot table, those old items might still appear in the drop down lists.

Sometimes though, the fields are calculated as a Count, which might not be what you want.

To fix this, you manually change the field to Sum, after it’s in the pivot table.

How to locate and change the source data for an Excel pivot table.

For missing source data, steps to try to recreate it.

To follow along with the tutorials, you can download the Date file.

The zipped file is in xlsx format, and does not contain macros.

Then, when you close the file, Excel can save the source data in this pivot cache, or clear that memory.