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.”

GETPIVOTDATA2

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: