Avoid the Dread GETPIVOTDATA

It has a purpose, but GetPivotData has confused and frustrated many Excel users. You want to write a formula using PivotTable cells and get a clunky, inflexible result. Here’s how to stop it. 

Click anywhere inside your PivotTable, then select Analyze, Options, and uncheck “Generate GetPivotData.”