Pivot Table Field Name Invalid?

**razorsharpe** · 09-01-2006, 09:10 AM

why? o why? o why?

I cannot add a Pivot Table to my excel sheet, because I keep getting the message "Pivot Table Field Name Invalid". It has an automatic name, not my fault (thanks MS-B.S.). If I select another sheet which contains only one list of information I can create one, but how useless is that, when I want the real power of this feature unleashed on the whole database (sheet). What is wrong with this function of Excel and how do I work around this cumbersome issue that MS has caused?

thanks in advance,
John

**thesundayman** · 09-01-2006, 10:09 AM

Are you sure there isn't a blank cell at the top of one the columns where the pivot table is looking for a field name? This may not be one of the coulmns you will be using but the pivot table needs ALL the columns to have a name!

**razorsharpe** · 09-01-2006, 10:29 AM

Yes, I am 100% sure there are names on all and even defined names for the columns. I copied the cells to a different (new) worksheet and it worked. Why will this not work

thanks for the response