+ Reply to Thread
Results 1 to 2 of 2

Don't automatically give totals for columns?

  1. #1
    Forum Contributor
    Join Date
    08-22-2012
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2003
    Posts
    129

    Don't automatically give totals for columns?

    Hi.

    I use pivot tables and notice then whenever I add a new column it will give that column a total that I then have to right click and hide... I have all the "show totals" options set to off but this still happens. Is there any way to stop it from happening?

    It's not the end of the world but it does waste a few seconds with every new column to every pivot table, which adds up, and it's just another step to explain to not so skilled excel users in an already fairly complex process.

    Any ideas?

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Don't automatically give totals for columns?

    Hi

    Dont have your version but have a look at the link and see if that solves it for you.

    http://www.contextures.com/xlPivotAddIn02.html

    Chris
    Click my star if I helped Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1