ERROR - Pivot Table Field Name is not Valid

[rrs517]

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

 

[Oeldere]

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

 

[rrs517]

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

 

[Oeldere]

Glad i could help.

Thanks for the feed back.

 

[muralikrish2008]

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

 

[irishjoeydee]

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!)