+ Reply to Thread
Results 1 to 2 of 2

Pivot Table tools

  1. #1
    Registered User
    Join Date
    06-10-2011
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2002
    Posts
    1

    Pivot Table tools

    I am playing around trying to familiarise myself with PivotTables in Excel 2002. I have found a lot of information on the intranet, but can find nothing relating to two of the icons on the PivotTables toolbar. These are "Include Hidden Items in Totals" and "Always Display Items".

    No matter what I do, the "Include Hidden Items..." icon is always greyed out on my toolbar and clicking the "Always Display Items" icon appears to do absolutely nothing.

    Can anyone help? Tell me what these do and and example of when they would be used / how to activate the icon?

    Thanks

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,219

    Re: Pivot Table tools

    Hi SBJ and welcome to the forum
    Does this help?
    http://office.microsoft.com/en-us/ex...005199384.aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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