pivottable

  1. M

    Update Source Data for Pivot Table

    Hi all! I have a workbook that contains a pivot table, a data set, and several user input pages. I have a macro that updates this data set, and the size of the set may change between each update based on user inputs elsewhere in the workbook. I would like the Pivot Table to update as well...
  2. G

    PivotChart formatting help

    Hi all, I have a fairly large dataset that is broken down as minute-by-minute data. I am plotting various charts from the PivotTable data, generally using averages. I have "Time" in the row field on my PivotTable, but when I plot a chart it gives me some strange time values along the X axis...
  3. S

    Can pivot tables in worksheet be shared in another excel workbook and changes dynamically?

    Hello all, I have a workbook with about 10 worksheets. One of the worksheets contains pivot tables and slicers. I would like to check if it is possible share/extract this worksheet with pivot tables on another excel workbook, and that changes will be updated dynamically. Reason being I would...
  4. C

    Add a column to calculate remaining budget

    I have a PivotTable that shows expenses across departments. Each department has a set budget for the entire year. In addition to the grand total that shows how much each department has spent, I would like a column that shows how much of their budget is remaining. For example, the DA department...
  5. M

    Error: 'We can't summarize this filed with Sum because it's not a supported calculation for Text data types.'

    Hey Everyone, I am trying to attach a slicer to 2 Pivot Tables based on different data sources. I am following the method as shown in this Youtube video https://youtu.be/p9VD0rsC_bk . I am using it as a guide for my own excel spreadsheet. For my own spreadsheet, I have ticked the box where it...
  6. M

    Loop through PT

    I have a PT that is created from a Power Pivot table and I want to loop through each item in the 1 column of the PT. I thought the following would workSet ptField = ptPivotTableList.PivotFields("Proper Name")but I am getting a 1004 error, Unable to get the PivotFields property of the PivotTable...
  7. M

    I can't Regenerate a Pivot Table with new data

    This is the code I'm using:Sub a_Recalc_Pivot_Table() ' Macro to recalculate Pivot Table. ' 2/7/12 Modified. WML ' ' 7/29/19 Copied from "Offfice Development Center". WML Call Initialize_Globals Data.Activate 'Determine the data range you want to pivot...
  8. P

    A PivotTable Report cannot overlap another PivotTable Report

    Hi All, I am receiving this message "A PivotTable Report cannot overlap another PivotTable Report", in a workbook of about 15 sheets or so. Usually when I have this error, I can identify where it is coming from by looking for overlapping pivot tables. I seem to have maybe identified the sheet...
  9. T

    VBA to select a date range of data return from a table

    Hi guys, I am really new to VBA so I am looking for a way to create a VBA code so that it can return results on a pivottable for me, within a certain date range, which will be determined by two cells. i.e A5 = start date A6= End date And these two would be used as references for the pivot...
  10. T

    Can I get a PivotTable calculated field that is the difference of two averages?

    Lets say i have these PovotTable fields. FieldRow, FieldData1 and FieldData2. I put FieldRow in the Row area of the PivotTable, and so data fields will be summarized for each item of FieldRow. I put FieldData1 and FieldData2 in the Data area, and set them to aggregate by Average. I would like...
  11. S

    VBA USERFORMS : Combobox values into Pivot Chart table

    Hi Friends, I have a User form with a comboBox caled "cmbpivotvalue" . When i press Submit/validate button "cmbValidate" in the userform , the values in this comboBox should go to the "VALUES" section on the PivotChartFields (please refer the screenshot) . Please help me to create code for...
  12. M

    Get only data on PivotTable

    If I double click Grand total on PivotTable I get all columns of data including those not on the PivotTable. Is there way to get the data only for dimensions that appear in the PivotTable only ? Thanks
  13. K

    Default classicview Pivottable

    Hello, Is there a way to set each new pivottables to classicview by default in Excel 2013 ? Thanks in advance.
  14. O

    Error: PivotTable report cannot overlap another PivotTable Report

    Hey all. I've found where other people have had this error but those solutions haven't helped me solve this one. Long story short I built this for another employee about a year ago and my memory is fuzzy on some specifics. There's only one PivotTable on the sheet. I get the typical error...
  15. R

    Question regarding recommend PivotTable

    Hello everyone, My name is Ryan and I am new to the forum. I am fairly new to learning excel. I am currently enrolled in a class at Northern Virginia community college to help to become more familiar on how to use excel. I was wondering if anyone could help me to understand how recommend...
  16. U

    VBA Error: Run time error 1004

    Hi All, Im not really an expert with coding VBA and hence rely on recording Macros. I have one macro which i awlays run but for some reason today i keep getting an error message as per below. "Run time error 1004" - The PivotTable field name is not valid. To create a PivotTable report, you...
  17. D

    Intelligent autofill based on cell values.

    Hello, I have built a sales report dashboard which is to be updated monthly with around 2000 rows of input. The data I input has the following categories/columns: Date | Sales rep | Product | Quantity | Value | Product category | Brand. Sadly, the company's software does not export the...
  18. J

    Excel vba - filter pivots

    I have 2 different pivot tables on different Excel sheets using different data sources. They both have a "Style" column that can be filtered. When I filter for style on one pivot table I want the other pivot table to automatically (or with a button) filter for those same selected styles. I am...
  19. J

    VBA Filter Pivot Tables on different sheets

    I have 2 different pivot tables on different Excel sheets using different data sources. They both have a "Style" column that can be filtered. When I filter for style on one pivot table I want the other pivot table to automatically (or with a button) filter for those same selected styles. I was...
  20. P

    PowerPivot & Excel Row Level Security - How secure is this solution?

    Afternoon All, Before I begin, I know that you can't implement true RLS in excel - but due to pricing, Power BI is a non-starter. These excel models will also not be shared outside of my organisation. The solution I'm using is obtaining the windows username via VBA, pasting it into a cell/table...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 40
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top