There are example GetPivotData formulas in Excel's Help. Can you base
your formula on one of those?

If not, describe your pivot table layout, and which version of Excel
you're using, and someone may be able to help.

Wozzle wrote:
Is anyone a Pivot Table Guru?
I need to use the GetPivotData formula to get a subtotal line within the
Pivot, but when I use the equals I keep getting a reference error!

eg. Need to access Sep Hrs - cannot get total as I receive a ref error.
But for Total hrs I can use the formula!!

Is there a way I can use the getpivotdata formula or another formula to
access these category subtotals from the pivot table!! The pivot table is
dynamic aswell, and its range grows as you add in additional weeks..

Help!!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html