1. R

    URGENT FOR MAC: Remove pivot table data fields in Excel for Mac 2011

    Hi guys Sorry for using the word urgent. But I have limited time with a borrowed machine and really need to solve this issue asap. I've written an procedure to automatically remove all existing data fields in a pivot table. The code works perfectly on a Windows PC but not on a Mac. Can you...
  2. S

    VBA - Add more than 1 pivot table data fields

    Hi, I am automating a pivot table and I want more than 1 data fields. For the row fields it accepts an array: pt.AddFields RowFields:=Array("GPProject", "Department",) But it won't accept that for the data fields, below is the code for a single field pt.AddDataField...
  3. D

    Datafield in pivot table switched!

    I used the record feature to pick two categories "Sum of vol_gross" and "Sum of vol_net" and put those in the Data field. After the table was created I dragged them both to the Totals area so that it reflected the correct values. For a while the vol_gross was in column J and vol_net in column K...
  4. T

    VBA Pivot Table- Datafields Horizontal to Vertical

    Hey guys, I've been following a book on how to create a pivot table using VBA. The code in the book works fine and it's doing what it's supposed to be doing. But i don't understand how to change how the Datafields are displayed. It's listing the datafields horizontally one on top of the...

Some videos you may like

This Week's Hot Topics