1. TheMacroNoob

    Sum Distinct within PivotTable?

    Hello all, I am trying to use PivotTables to summarize and filter data. I have various tables that all do what I want, except for one. I have a list of RMs (People), their Units Under Management, and Total Claim Cost per RM. Some properties have multiple claims, thus repeating data such as Unit...
  2. B

    Refresh All & Pivot Tables

    Hi. I have a spreadsheet with probably three dozen pivot tables spread across multiple sheets. I am sure there is a more efficient way of doing it. I've never gotten around to learning PowerPivot or macros or whatever else I would need to use, so I use what I know. This spreadsheet gets updated...
  3. S

    Drill down in created measure, how to?

    Hi there I want to use a measure to count the number of times certain words appear in a column and based on that, be able to drill down and look at those records in a new sheet when double clicking on the value. I am able to create explicit measures in the data model, but am not able to drill...
  4. C

    VBA Disconnecting Slicer, updating Pivottable source, reconnecting Slicer

    Hi guys, I'm running into a little but of a problem that I'm hoping someone here can help me with. On a daily report that I run I have 8 different PivotCharts from 8 different PivotTables, all from the same data source but displaying different parts of it. I also have one slicer and one...
  5. K

    VBA Protected Book with PivotTables -- Allow "Show Detail" feature and delete sheets

    Hello, I have a project requiring the use of PivotTables in a protected Workbook. I need to code a macro that will allow users to drill down into the PivotTable values, and then will automatically delete them once the book has been closed. I have found plenty of threads demonstrating how to do...
  6. A

    Pivot Table Refresh

    Hi All, I wondering if someone would be able to help. I have a workbook that has a sheet labelled as "Pivots" with the data kept in another sheet called "Calls"...I am trying to find a way that would allow me to update the data in "calls" and for the pivots (named as PivotTable1 to 9) to...
  7. M

    VBA with PivotTables

    I have two workbooks, each containing a pivot table. The two pivot tables contain the same fields, but the values are different. What I'm trying to do is use VBA to add Fields to "Rows", one at a time. So let's say the pivot tables have 5 fields: Dollars, Account, Activity, Category, Category 2...
  8. M

    Loop Adding Calculated Fields to Multiple Pivot Tables

    I'm trying to add two calced fields into 24 pivot tables across 8 worksheets. It it based on choice of a data validation list in B4 on Sheet 1. The code pasted below works for all of them except for the last 5 tables on Sheet1. I have Field Headers disabled on all Pivot tables. The weird thing...
  9. M

    Hide a single pivot table?

    Hi All, I've written a some code to hide charts and pivots the charts part works perfectly however as i have 12 pivots all feeding from the same source when i try and hide one of them using "tablerange2.entirerow.hidden = true" all of the pivot tables are hidden not just the one selected. I...
  10. W

    VBA, PivotTable: Move the first PivotField, regardless of name, to the last position

    I have a workbook with about 30 tabs that each have 6 PivotCharts. Each PivotChart has 12 PivotFields (Values) corresponding to the months of the year. These are basically creating a rolling year effect after data is updated. To do this effect, I need to take the PivotField in .Position = 1...
  11. C

    run-time error 1004 Unable to get the PivotFields property of the PivotTable Class

    I'm running into a strange problem, for many years I have used these excel macros and all of a sudden I started to receive errors that only appear on one computer. This macro and pivot issue doesn't exist on any other computer I have tried. So excel was uninstalled and a fresh clean updated...
  12. A

    Use drop down list from cells as report filter for multiple Pivot tables in same worksheet using VBA MACRO

    Hi All, Please note:- I know about slicer but don't want to use and wants a vba macro only. Below is my query I've 3 pivot tables in same excel worksheet. All 3 pivot tables have 5 report filters and out of them 4 report filters are common. I want to use a drop down list from cell b4, b5, b6...
  13. T

    hung up at “Unable to get the PivotTables property of the Worksheet class”

    <tbody> I keep getting this error Unable to get the PivotTables property of the Worksheet class from the code below (I used recording button to have these coding from Excel) I'm not sure what is wrong, but any help would be helpful. It hung up at the "<code>With ....End With"</code> part...
  14. M

    Macro to format pivot table field with currency format while leaving other fields as general

    I am trying to write a macro to format whatever pivot table I am on in the active workbook on the active sheet that will format an individual data field that will always have the name "dollars". This is the code I have so far: The code I have is as follows: This is try number 1 Sub format()...
  15. S

    How do I change the color of the line in a line chart according to value?

    I have a line chart that tracks "change per week." Some weeks have negative values, some have positive values. Essentially, I want to specify parameters so that negative values are colored green, values near zero (possibly + or - 100) are orange, and positive values are red. Is there a way to...
  16. C

    Multiple Consolidation Ranges - Multiple Date Columns

    Hello, I have a single sheet with four columns (State, City, Start Date, End Date). I would like to create a pivot table that would show the State and City in the rows, a single row of dates on the columns, and then a count of the Starts and Finishes for each State/City combination. Something...
  17. S

    Speedometer Chart from -100 to +100

    Hi everyone, I created a speedometer chart using a combination of a doughnut and pie chart (in one) based off a YouTube tutorial I found here: https://www.youtube.com/watch?v=f6c93-fQlCs The problem I'm having is that the needle only goes from 0 to 100, but I need it to go from -100 to +100...
  18. G

    Trying to do some custom Pivot Table summaries, wondering if this is possible...

    Hi all, Pretty straightforward question, I hope. I have a data set that I'd like to see if I can get set up in a pivot table in a custom way. The data is being pulled out a SQL database and looks like this when I retrieve it (dummy data created for example purposes - its actually quite a bit...
  19. M

    Skipping an i, or multiple i's in a Loop - please help

    I am writing some code to generate multiple pivot tables in excel. My spreadsheet is set up with survey responses to a variety of questions with the question number across the top, and the survey responses below in the column. My problem relates to questions 8, 10, and 13. As you can see in...
  20. J

    Run-time error '5' when creating a new pivot table

    I'm getting a "Run-time error '5': Invalid procedure call or argument" when running my code (below). I cannot figure out what I'm doing wrong here. Does anyone have any suggestions? Dim APXPvtSrcData As String Dim APXPvtCache As PivotCache Dim StartPvt As String Dim...

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