Have you ever clicked on a cell within a Pivot Table whilst building a formula and instead of the cell reference appearing in said formula, you get some strange looking GETPIVOTDATA function?

In this video I explain what GETPIVOTDATA is, when you need to use it, when to avoid it, the gotchas to watch out for and how to disable it (spoiler alert: I don’t recommend you do that!). Links to the video and individual sections below…

Referencing a Cell in a Pivot Table by Typing

Referencing a Cell in a Pivot Table by Clicking

When to Use GETPIVOTDATA

Check Whether Generate GetPivotData is Enabled

Copying GETPIVOTDATA Gotchas

Disable Generate GetPivotData