pivot tables

Hye Excel Experts, This code I found seems to be really awesome. However, I couldn't get it to refresh the pivot tables automatically when I park the selection list in another worksheet. It only works when the list in the same worksheet as the pivot tables. Please help to correct the code below...

Hi All, please, please consider tackling this, it would be a massive step in moving a career spreadsheet forward! So I have a pivot table that subtotals thousands of mutual funds by "asset classes". The pivot has several Value columns that needed to be ranked (within each sub total). I ranked...

Hi all, I'm hoping someone can help. I have a dashboard that I must now add to. The entire dashboard is running from a date range in dropdown selections i.e. a from and to date in sheet 1. I now have set up another sheet with several pivot tables. I need to be able to link these pivot...

Hi All, I'm trying to create a macro to update multiple pivot tables in one worksheet with an expanded source data location. For example, I have added more data for a new quarter to the range that the pivot tables are reading from and I wanted to automate the process of updated the data source...

Hi All, Trying to filter a pivot field using a macro. Following is the image for the pivot table Imgur: The most awesome images on the Internet And below is the code that is giving me the error (In red). Thoughts?? Sub TestPivot() With ActiveSheet.PivotTables(1) .PivotFields("Business...

Can I use a Pivot Table for other functions that just numerical summations? Looking through the settings everything looks to be based around calculations or math. However, my data isn't financial. I have a lot of user ID #s, computer names, and dates. Please let me know if you need more...

I'm building a dashboards with Pivot tables and slicers. I have shaded the cells green, but when I click a slicer, the cells 'behind' my Pivot Table are white. Any advice on how to control this without VBA?

Hopefully straightforward question, can't find a straight answer after extended searching: Can you apply a filter to a pivot table field without the field being in one of the four categories (Filters, Columns, Rows, or Values)? If so, how? If not, why not? Say I am building a pivot table and...

Hi all, The logic on this one is stumping me. Hoping someone can help me out, as I'm not quite following what the issue is here: I'm building a pivot table from data using VBA. When adding a row field, if I am adding it based on a variable it fails, but if I add it explicit it is fine...

Hey guys, I am trying to create a pivot table with VBA based off of some data that I have. Here is my code: Option Explicit Dim dolSht As Worksheet, hourSht As Worksheet Dim sumSht As Worksheet, byCustSht As Worksheet, allCostSht As Worksheet Dim ptCache As PivotCache Dim pt As PivotTable...

Private Sub Worksheet_Activate() Sheets("sheetname").PivotTables("PivotTablename").RefreshTable End Sub Dear sir I have used this vba code On a worksheet to auto refresh the pivot table on another sheet . It was working But I have 2 more worksheets in my inventory , i am unable to do...

I've been Googling and reading these forums for a while but still haven't figured out how to accomplish what I want to do. I'm not sure how to describe what I need in a way that's both concise and clear, so let me show you what I've got, and explain step-by-step. My data look like this...

Hello, I know that you can adjust the layout of a pivot table field list, but I want to know if you can adjust the size of the Areas Sections. (Filters, Rows, Columns, and Values sections) This is just a big peeve of mine when I'm trying to build out a big pivot table with lots of rows. Anytime...

Hi, I am new(ish) to pivot tables and looking for some help please: We have had a group of people assess how good they are at a number of activities by rating themselves Red, Amber or Green, and I now want to pull together a single table showing how many red, how many Amber and How many green...

Pardon my Excel ignorance, as it has been 12+ years since I have used it. Back then, I was using a windows computer and now it's a MAC with Excel 2016. I don't know if data validation, pivot table, filtering, etc. would be the right choice or even a combination of? Speaking of combination...

Created a Pivot Table with VBA using Excel 2010 and now the slicer controls are greyed out; creating the same Pivot Table manually does allow use of the slicer controls. Is this a limitation of VBA created Pivot Tables?

Hello! I have a macro below that is supposed to filter out all 'no data' ("") values. The data set will be added to constantly so I want new values to be included but I don't want blanks. However, the macro returns Error 1004: Unable to get the PivotItems property of the PivotField class...

Hi there, please help me S.O.S. I have a table that lists 1000+ individual student details under columns labelled as ClassID, Name, ClassRoomNo, Subject1, Subject2, Subject3,.... Subject9. The subjects are text entries such as 'Psy', 'Latin', 'Math', 'Art', 'French', ... and so on. Each...

Hi I have the below code to create a pivot table and have set the pivot table as the variable, PT: Dim WB As Workbook Dim WS As Worksheet Dim WSsb As Worksheet Dim FinalRow As Long Dim FinalCol As Integer Dim PRange As Range Dim PTCache As PivotCache Dim PT As PivotTable Dim PF As PivotField...

I'm using Mac Excel 2011, trying to sort a pivot table but it's not behaving. I found this thread: [SOLVED] Excel 2011 - Trying to Sort Pivot Table and tweaked the code to suit my names of things: Worksheets("performance").PivotTables(1).PivotFields("date").AutoSort xlDescending, "Row...