GetPivotData Excel 2007

[Jworley2]

There was a command in Excel 2003 that was GetPivotData that would let you use relative references in a pivot table in a formula. I cannot find that command in Excel 2007. Is there a equivalant command in Excel 2007?

 

[Andrew Poulsom]

Welcome to the Board.

According to this the function is still there:

http://office.microsoft.com/en-us/excel/HP100624771033.aspx