O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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!

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required