pivottable options

  1. M

    Pivot Table link to external workbook and naming

    Hi Guys,Has anyone done / or have an example of a pivot table that is link to an external workbook.Solution Brief:I have master workbook with 12 worksheets Jan - Dec, here there are 4 columns with sales data etc, this is called master.xlsxNow I can create the pivot table and read the data from...
    • markfell
    • Thread
    • links links between workbooks pivottable options refresh
    • Replies: 0
    • Forum: Excel Questions
  2. N

    created pivot table in vba and label filters are greyed out (disabled)

    Hello! The pivot table gets created fine but when I go to filter the item labels, the "Labels Filters" option is greyed out (disabled). Any idea why it would default to that and how to fix it? Any help would be greatly appreciated!
  3. N

    Enable "Display item labels when no fields are in the values area" via VBA?

    I created a pivot table via VBA and I want to set this checkbox to true within the VBA. I can manually do this by going PivotTable Options-Display but I have over 100 pivot tables so I was hoping there was a better way to do it. Any suggestions would be greatly appreciated...
  4. G

    How do I set defaults for "PivotTable Options?"

    In the PivotTable Options pop-up box on the Data tab, I like to set the "Number of items to retain per field:" box to None. By default, Excel has it set to "Automatic." How can I change the default to "None" for all my Excel files?
  5. Long Nose

    Excel 2007 / PivotTable Options / Data question

    Hi All, I am frustrated with XL 2007 pivot tables. I am unable to see "Change Source Data" on the "Data" tab under "Pivot Table Options." The help menu says it should be there, but it isn't. These tables were created in XL 2003 and I just want to see what the pivot table is currently...

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