pivot table update

  1. Y

    VBA to intersect cell changes (both data validation) and action separate functions

    Hi Everyone, on my worksheet I have two cells B3 and C3 which have data validation. So what I want to do is when either of the cells change, it will update two pivot table's filters. (Target & Actual) Below is what I got working when looking at only B3 and updating the Region. The values...
    • yhtomitl
    • Thread
    • data validation intersect pivot table pivot table update vba
    • Replies: 3
    • Forum: Excel Questions
  2. L

    Pivot Table Update Change event

    Hello - I have a pivot table change event that runs on pivot table update. This process works great, provided the changes occur on the sheets that the pivot tables reside. However since we have multiple sheets with multiple pivots my users wanted a "workbook control sheet" added that contains a...
  3. S

    Pivot table only updates when slicer selection is made

    I have data model set up in PowerPivot that gets data from SQL database. I have set up multiple pivot tables with slicer to select period (Actual, QTD or YTD) and currency (EUR or USD). When I refresh the datamodel my pivot tables do not update although new data has been loaded. But when I...
  4. C

    update pivot table

    Hello, I have 3 pivot tables from diferent origenes. I would like to update each one when I select some filter in the slicer (?). How can I do it? all of them has 2 fields in common, "Service" and "Date". I want that, when I select, for example, "Print" or "Navigation" service (or both), the...

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