Referencing PivotTable Data from Worksheet Cells

Excel's GETPIVOTDATA function lets you reference an item in a PivotTable by its position within the field structure of the table, not by its current worksheet location. With this function, you can perform calculations on PivotTable data without worrying about what will happen to your calculations if the table is rearranged. As long as the referenced data continues to exist somewhere within the PivotTable, the GETPIVOTDATA function will find it. If you reference a table item and subsequently remove that item from the table, the function returns #REF!

Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.