Everything you ever wanted to know about GetPivotData is right here including
where to find the toolbar button allowing you to toggle...
http://www.contextures.com/xlPivot06.html
--
HTH...
Jim Thomlinson
"Pete F" wrote:
Trying to link to a pivot table but you get the get pivot label. Want to
turn it off????