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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Pivot Table Error 1
Pivot table "Sum of" or "Count of" 1
Pivot Tables - Filtering on summed values 0
Excel 2007 - Pivot Tables Include Filtered / Hidden Values inSubtotal / Total 0
Filtering by group in pivot table 0
Calculated Item in Pivot table 1
PivotTable - Filter Row 0
pivot table missing rows? 0

Top