pivot-tables

  1. S

    Update multiple pivot tables to the last row of data.

    I have multiple pivot tables on 5 sheets named in the code. Data source for all of them is "CUIC data", which i update daily. I want to change the data source and refresh all the pivot tables in all of my worksheets. The code i have works for one sheet, but i dont know how to get it done for...
  2. V

    Coding the DistinctCount function in VBA for creating pivot table

    Hi, I tried to run this code, but it calculate "count" instead of "distinctcount" in case of datafield "TT". If I do pivot table manually, in the Create PivotTable dialog box I have to check the box next to the label “Add this data to the Data Model”. But I don’t know how it works in VBA code...
  3. O

    Simple pivot table Driving Daniel Crazy.

    This is incredibly frustrating. I'm simply trying to add a report filter to a pivot table. I want it to look like the following table. Instead the report filter appears above the pivot table and refuses to filter. In cell A2 the formula would be =GETPIVOTDATA("YACCT",$A$9), to count each number...

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