• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Analyzing Data with PivotTab... > Referencing PivotTable Data from Wor...

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!


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint