Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Pivot Table Field Name Not Valid (2002)

    I have a pivot table that was created some time ago and now new data has been added in the Workbook and worksheet.
    I've tried to change the range of the data but get the message "field name not valid"...

    What is this trying to tell me and what must I do to fix it?

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

    Re: Pivot Table Field Name Not Valid (2002)

    Each column in the source range of a pivot table should have a unique, non-blank name. Check the first row of the new source range - there should be no blank cells and no duplicate names.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Pivot Table Field Name Not Valid (2002)

    DUH. Thanks...that was the issue I overlooked. Thanks, again.

Posting Permissions

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