Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts

    Pivot Table in Excel 2010

    Hello
    I have a pivot table that was created in Excel 2003 and the results are correct. When the same pivot table is created in Excel 2010 it does not give the Grand Total for several fields. In my attachment the results that don't show are highlighted in yellow. Thanks for any assistance you can provide.

    MOstate
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi

    Is the Excel2010 pivot table created via VBA code, or manually??

    zeddy

  3. #3
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Thanks for the reply. It is created manually.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a sample copy of the workbook and macro?

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts
    I tried to attach but the file size is too large. Any suggestions? Thanks!
    Last edited by MOSTATE; 2012-01-30 at 11:43.

  6. #6
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts
    I am attaching the file is zip format so hopefully you can retrieve the information. The attachment was created in Excel 2003 and the pivot table is complete. When you recreate the pivot table in 2007 or 2010 the pivot table is incomplete. Thanks!!
    Attached Files Attached Files

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I can replicate the problem in 2010, so I assume it is either a "bug" or a new "feature" of XL2007 and XL2010. You don't even have to recreate the tables to notice the problem. Just refreshing the table in XL2010, wipes out the Grand total when you are counting TEXT values. If you Find/replace the "X"s in those columns of the table with a number (eg I tried with 0 and 1), it seems to give you want you want in the pivot table.

    [If your data table needs to appear as "X", you can replace the X with a zero, then add a custom format of (no brackets) [;;"X"] to display the zeroes as "X"...]

    Steve

  8. The Following User Says Thank You to sdckapr For This Useful Post:

    MOSTATE (2012-01-31)

  9. #8
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Steve
    Thank you so much, your solution works great!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •