pivot table fields

  1. W

    Misterious (to me) Pivot Table View

    Someone sent me an Excel file containing a single pivot table. A dozen fields reside in the pivot table field list within the ROWs box. One field resides in the VALUEs box. All of the ROW data fields (names) appear in the pivot table as columns, including the single 'value' field. I've never...
    • WHP3III
    • Thread
    • display column content pivot pivot table 2016 pivot table fields table
    • Replies: 0
    • Forum: Excel Questions
  2. M

    Pivot Table Fields

    I have inherited a spreadsheet that has pivot tables to summarize the data. The data source is a tab with only 10 Columns, A:J, but there are over 20 columns in the pivot table, many of which do not match the source data. These columns are listed in the Values section of the pivot table menu...
    • masonbp2
    • Thread
    • columns fields pivot pivot table pivot table fields
    • Replies: 1
    • Forum: Excel Questions
  3. N

    VBA "update" pivot table fields

    Hi, I have a pivot table that I need to update quarterly. The values are "Sum of 20134 DEC", "Sum of 20134 WAGES", and "Sum of 20134 EST". When I receive the new quarter's data, I don't want to create a new pivot table, but just refresh/ update the fields mentioned above. I have set the...
  4. H

    Syncing multiple slicers from different pivot tables

    I have a workbook with about 15 pivot tables. These pivot tables are linked to an Access database that holds the data and runs off of 5 queries. I am able to connect slicers so that I can minimize the number of slicers needed to 5, but I would still like to be able to use only 1 slicer to...
  5. H

    Pivot Table Calculation

    I have a workbook that has extremely large datasets with pivot tables that run off of them. I need to make multiple changes to the pivot table fields, but after every field filter that I select, the pivot table takes forever to calculate. Is there any way to pause/stop pivot table calculation...
    • Hartke2421
    • Thread
    • calculation pivot table pivot table fields pivot table filters
    • Replies: 3
    • Forum: Excel Questions
  6. R

    VBA expand all pivot table fields in Excel 2010

    Folks: How do you write a macro to expand all pivot table fields in Excel 2010. Hit + buttons on all like when recorded for just this one: ActiveSheet.PivotTables("PivotTable2").PivotFields( _ "Cost Center").PivotItems("77194").ShowDetail = True Thanks, Rowland

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