Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Pivot Table - Show Pages Function (Excel 2002)

    Hello!
    When using the "show pages" function in one of my pivot tables, the name of the "show pages" field does not come over to the name of the worksheet... for example, I have "name" in the page section of the layout... when I run the "show pages" option, normally all 10 different names show up as 10 different worksheets within the workbook I'm working in... in this particular example, 9 of the names show up with the individual names as the new worksheet names and one of the worksheets name shows up as "sheet8". This has never happened to me before... I've used this function in the past with maybe 25 different worksheets being generated, and this one only has about 12. Any ideas what might be causing the name to not transfer to the worksheet name?
    Thanks,
    Lana

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table - Show Pages Function (Excel 2002)

    Excel tries to give each sheet the name of the value from the page field. If this value contains a character that is not allowed in a sheet name, it'll give the sheet a generic name instead.
    The forbidden characters are <code> / : ? * [ ]</code>

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Pivot Table - Show Pages Function (Excel 2002)

    Ahhh...that would explain it... the name had a in it!
    Thanks as always Hans!
    Lana

Posting Permissions

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