In this video we explain the GETPIVOTDATA function of Excel. Why is it useful, how to use it and how to turn it off when you do not need it.
View more Excel PivotTable tutorials –
The GETPIVOTDATA function in Excel is used to query and extract data from a PivotTable. It can be incredibly useful, but is not always the approach that you want.
In this video we see an example of how useful it can be, but then another where it did not help so we disable its functionality.
Find more great free tutorials at;