ERROR - Pivot Table Field Name is not Valid
Results 1 to 6 of 6

Thread: ERROR - Pivot Table Field Name is not Valid
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2012
    Location
    Denver, CO
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post ERROR - Pivot Table Field Name is not Valid

    Please help. I have spent hours and no results. Any ideas greatly appreciated - I am a newbie to pivot tables
    Excel 2007
    No empty rows
    No empty cells
    No calculations in cells
    Field names look fine - no punctuation no merged cells
    If I select one column - any single column I can generate a pivot table but not with multiple columns

  2. #2
    Board Regular
    Join Date
    Dec 2011
    Location
    The Netherlands
    Posts
    2,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ERROR - Pivot Table Field Name is not Valid

    Are all columns condensed (e.g. you don't have gaps between column B en D)?

  3. #3
    New Member
    Join Date
    Nov 2012
    Location
    Denver, CO
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ERROR - Pivot Table Field Name is not Valid

    Hello Oeldere,

    THANK YOU !!!! That corrected my problem in 2 minutes. Oeldere, I had imported a table from a client and cleaned it up considerably (removed several hidden columns, removed blank rows and fields, made sure all field names looked reasonable, etc.) prior to posting my plea for help. However, since I did not create the table I did not spot 5 other hidden columns. As soon as I removed them the pivot table created instantly. I sincerely appreciate your prompt response and your expertise in spotting what I overlooked. This is an awesome site for Excel.

    Kindest regards,
    Richard

  4. #4
    Board Regular
    Join Date
    Dec 2011
    Location
    The Netherlands
    Posts
    2,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ERROR - Pivot Table Field Name is not Valid

    Glad i could help.

    Thanks for the feed back.

  5. #5
    New Member
    Join Date
    May 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ERROR - Pivot Table Field Name is not Valid

    kindly select the excel and check center and merger center, after that select a cell and now your pivot table is ready

  6. #6
    New Member
    Join Date
    Sep 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: ERROR - Pivot Table Field Name is not Valid

    Quote Originally Posted by Oeldere View Post
    Are all columns condensed (e.g. you don't have gaps between column B en D)?
    Just Thanks!! I screwed around forever trying to fix my problem then found your post. I had a blank column courtesy of a cut and paste error on my part.

    (This site/forum a great resource!)
    Last edited by irishjoeydee; Sep 5th, 2014 at 10:59 AM. Reason: add comment

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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