pivottable update

  1. T

    Excel VBA - Pivotfield filter doesn't update pivot table

    Hello everyone, This is my first topic :) I will explain in details : I have 4 pivot tables from different sources. I have another table with a list that I need to filter at the pivot table. In the end I expect to create a macro that reads this list, apply the filter and print the result for...
    • thiagofb
    • Thread
    • error pivottable pivottable field pivottable update set
    • Replies: 0
    • Forum: Excel Questions
  2. S

    Changing filter on multiple pivot tables

    On a particular worksheet within the workbook I have a bunch of pivot tables (excel 2007). The column header is "Wk Ending". This is the item that I need to filter. I used the code i show below. When I update the "Wk Ending" field all of the other pivot tables completely lose the filter. They...
    • samait
    • Thread
    • column header filter mutiple pivottable update
    • Replies: 1
    • Forum: Excel Questions
  3. G

    Update Multiple Pivot Tables with VBA

    Hey Guys I have a report that I put together monthly. The report contains 38 different pivot tables all of which reference a single separate excel workbook. I would like to write a VBA macro that changes the data source for all 38 Pivot Tables to a new excel workbook and updates each pivot...

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