pivottable menu vba excel

  1. A

    Changing OlapCube pivot table filter - Error “Unable to set CurrentPage property of PivotField class” error

    HI, I am trying to to change the the filter on a Pivot Table use the below VBA. I think the issue is with connecting to an Olap cube pivot table and not a normal pivot table. Highlighted in red is where the debug throws the error: "Run-time error '1004': Unable to set the CurrentPage property...
  2. K

    Help with Pivottable VBA and menu

    Hi, I'm a little bit stuck with a load of macros that generate pivot tables, i want to make it so i can make global changes easier. I currently have about 50 macros similar to the one below and making a change in all of them is a little time consuming. My idea was the split the macro up...

Some videos you may like

This Week's Hot Topics