1. S

    VBA PivotTable RowField CurrentPage Filter and PageField CurrentPage Filter

    I have two PivotFields. One will be a PageField while the other is a RowField. My macro will switch them, while also grabbing values from the top of the page and using these values as the CurrentPage for each Field. I get an error when running the macro that says Error 1004: Unable to Get the...
  2. T

    Pivot table output to pdf with multiple page fields

    Hi, I have a pivot table with 3 page fields, PageF1, PageF2 and PageF3 Each has a number of values including (All) I want to go through every combination of the pagefields and if the pivot table has actual values in the data region to output to a pdf file with a filename format: Pagef1 -...

Some videos you may like

This Week's Hot Topics