Pivot data problems
 

I am currently creating a pivot table which is always changing in width
due to the difference of grouping caegories from report to report.

I can currently pull the data using getpivotdata() but how do i pull
all the group headers?
this could be by macro or function.

best regards,
Alexandre Brisebois