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...
  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...

Some videos you may like

This Week's Hot Topics