Another way to extract data from a pivot table is with a GetPivotData
formula. There's information and examples he
http://www.contextures.com/xlPivot06.html
John Pivot Table wrote:
I´m trying to link a vlookup to a Pivot table, the problem is that every time
I change a parameter in the report filter, the number of columns in the table
changes; which messes up my formulas.
Is there a way to lock it?
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com