Pivot table and retaining filtered values

J

JLC

I am working with a pivot table that allows users to hide and show various columns by setting the .orientation to xlRowField (for show) and xlHidden (for hide). This works fine except when a column has been filtered and then hidden. The filter is no longer in effect and therefore the values do not sum properly. When I unhide the column the filter is back in effect

I am able to keep the filter in effect by setting the .orientation to xlPageField but the page field limitation of 256K is causing issues

Any assistance very much appreciated

Thank you
 
Top