pivot table filters

  1. S

    VBA to allow multiple value filters in pivot table?

    OK... after yesterday's great triumph, I'm now floundering again after having come up against pivot tables apparently not allowing multiple value filters. This is despite me having added pvt.AllowMultipleFilters = True to the code. It doesn't seem to be possible from the front end, either, but...
    • smarina
    • Thread
    • excel & vba filter pivot table pivot table filters vba
    • Replies: 2
    • Forum: Excel Questions
  2. 9

    Filtering in pivot need help with deselecting in report filter

    This is my current program: ActiveSheet.PivotTables("Prosthetics").PivotFields( _ "Otto Bock Strategic Business Segment B").CurrentPage = "(All)" With ActiveSheet.PivotTables("Prosthetics").PivotFields( _ "Otto Bock Strategic Business Segment B")...
    • 999HelpPlease
    • Thread
    • piivot filter vba pivot filter pivot table filters pivot table report filter report filter
    • Replies: 0
    • Forum: Excel Questions
  3. G

    Apply date filter in PivotTable from values in another PivotTable

    Hi. I am not sure if this can be done. I've found plenty of code to apply a report filter to a PivotTable based on a cell value but what I am after is a little different. I have a PivotTable that pulls up the min and max dates for selected records (Table1). Right now, users then use these...
  4. B

    Using VBA to Automatically Filter and Pull Data from a Pivot Table

    Hi guys, I'm loving this forum so far, I've always subscribed to the beleif that if you're trying to learn any new skill, surround yourself with as many 'gurus' as possible. You've all been a huge help. So for everyday purposes I'd consider myself an 'intermediate' Excel user. I'm looking to...
  5. H

    Pivot Table Calculation

    I have a workbook that has extremely large datasets with pivot tables that run off of them. I need to make multiple changes to the pivot table fields, but after every field filter that I select, the pivot table takes forever to calculate. Is there any way to pause/stop pivot table calculation...
    • Hartke2421
    • Thread
    • calculation pivot table pivot table fields pivot table filters
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top