GETPIVOTDATA is a powerful function in Microsoft Excel that can be used to query an existing pivot table and retrieve specific data based on the pivot table structure. The advantage of GETPIVOTDATA over a simple cell reference is that it collects data based on structure, not cell location. GETPIVOTDATA will continue to work correctly even when a pivot table changes, as long as the field(s) being referenced is still present. In this blog post, we will show you how to use the GETPIVOTDATA function to get the data you need from your pivot table!