pivottables

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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()...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. X

    Script causing data source to be corrupt(?) after running the script.

    Hi, I've a code which runs to refresh all pivots I've listed in an excel file with a specific data source, also listed in the cells of the excel file. The code is able to execute, and refreshes the data, however, the data source range becomes corrupt after? It throws me error: "The PivotTable...
  19. H

    VBA Update to Multiple Pivot Tables

    Hello. New member. I had a situation with a dashboard (Excel 2013) that consists of various tables, charts, and text. We been asked to expand the backend data and allow a user to choose their own dates. At first I thought this would be easy by way of Slicers and the Timeline function...
  20. G

    if statement help -

    So I need to capture the Name and corresponding Total. Notice that the Employee total is varying cells below the name - For Bobby Jones its 3 down and Ricky Bobby its 4. For example the desired data would read like this: <tbody> A B 1 Bobby Jones 300 2 Ricky Bobby 1,100 </tbody> The...

Some videos you may like

This Week's Hot Topics

Top