Hi everybody,

This forum has been a lifesaver. I've been able to find everything I've needed without posting a question until now.

Does anybody know any VBA code to remove all fields from pivottable column labels but not removing fields from anything else? The filter, row labels, and calculated fields should remain the same.

I've only had luck removing all fields, but I want the pivottable to have all the preset row label/filter/calculated fields the same. just no more columns.

Thanks!

- TJ