I am trying to resolve an error when I try to set up a Pivot Table. The error
says that the field name in not valid. (And yes I have read to "pat"
Microsoft answer that it is because of a blank cell in the header.)
Points that may help:
There are no blank cells in the header row.
There are no hidden columns.
The range is not adding a blank row or column below or at the end.
The dynamic name range works in other instances such as a regular chart.
I can "Go To" the range and it highlights the correct data.
I can open the Insert/Name/Define dialog box and click in the middle of the
range definition and it highlights the correct data.
I had several Pivot Tables working with this data range, each on separate
sheets, but as I tried to add some additional ones I started getting this
message so I deleted all of the worksheets with Pivot Tables and tried
starting over and now it will not allow me to create any.