I have a lot of data and I have created some Pivot Charts and Tables from
that data. I notice that I didn't group some of the information and that I
have a speeling mistakes in some of my categories. Once I had corrected the
things that needed to be corrected, I went to data refresh in my chart and
table and I got a this message "The Pivot table field name is not valid. To
create a Pivot Table report, you must use data that is organized as a list
with labeled coloums. If you are changing the name of a Pivot Table field,
you must typr a new name for the field". Could anyone help me with this. I
have changed infor. before but never go this error message.

Hi

It sounds as though one of your cells in the header row is blank.

--
Regards

Roger Govier


"Pivot Tables 101" <Pivot Tables wrote in
message ...
I have a lot of data and I have created some Pivot Charts and Tables
from
that data. I notice that I didn't group some of the information and
that I
have a speeling mistakes in some of my categories. Once I had
corrected the
things that needed to be corrected, I went to data refresh in my chart
and
table and I got a this message "The Pivot table field name is not
valid. To
create a Pivot Table report, you must use data that is organized as a
list
with labeled coloums. If you are changing the name of a Pivot Table
field,
you must typr a new name for the field". Could anyone help me with
this. I
have changed infor. before but never go this error message.

None of the headers are blank on the pivot table or the charts or tables
created. I have never had this problem before.

"Roger Govier" wrote:

Hi

It sounds as though one of your cells in the header row is blank.

--
Regards

Roger Govier


"Pivot Tables 101" <Pivot Tables wrote in
message ...
I have a lot of data and I have created some Pivot Charts and Tables
from
that data. I notice that I didn't group some of the information and
that I
have a speeling mistakes in some of my categories. Once I had
corrected the
things that needed to be corrected, I went to data refresh in my chart
and
table and I got a this message "The Pivot table field name is not
valid. To
create a Pivot Table report, you must use data that is organized as a
list
with labeled coloums. If you are changing the name of a Pivot Table
field,
you must typr a new name for the field". Could anyone help me with
this. I
have changed infor. before but never go this error message.

Hey I check before when I left my last message but then I noticed something
was hidden without a title. You were correct. Thank you for your help.

HAPPY HOILDAYS

"Pivot Tables 101" wrote:

None of the headers are blank on the pivot table or the charts or tables
created. I have never had this problem before.

"Roger Govier" wrote:

Hi

It sounds as though one of your cells in the header row is blank.

--
Regards

Roger Govier


"Pivot Tables 101" <Pivot Tables wrote in
message ...
I have a lot of data and I have created some Pivot Charts and Tables
from
that data. I notice that I didn't group some of the information and
that I
have a speeling mistakes in some of my categories. Once I had
corrected the
things that needed to be corrected, I went to data refresh in my chart
and
table and I got a this message "The Pivot table field name is not
valid. To
create a Pivot Table report, you must use data that is organized as a
list
with labeled coloums. If you are changing the name of a Pivot Table
field,
you must typr a new name for the field". Could anyone help me with
this. I
have changed infor. before but never go this error message.

Hi

Glad you found it.
All the best to you for Christmas and the New Year.

--
Regards

Roger Govier


"Pivot Tables 101" wrote in
message ...
Hey I check before when I left my last message but then I noticed
something
was hidden without a title. You were correct. Thank you for your
help.

HAPPY HOILDAYS

"Pivot Tables 101" wrote:

None of the headers are blank on the pivot table or the charts or
tables
created. I have never had this problem before.

"Roger Govier" wrote:

Hi

It sounds as though one of your cells in the header row is blank.

--
Regards

Roger Govier


"Pivot Tables 101" <Pivot Tables
wrote in
message ...
I have a lot of data and I have created some Pivot Charts and
Tables
from
that data. I notice that I didn't group some of the information
and
that I
have a speeling mistakes in some of my categories. Once I had
corrected the
things that needed to be corrected, I went to data refresh in my
chart
and
table and I got a this message "The Pivot table field name is not
valid. To
create a Pivot Table report, you must use data that is organized
as a
list
with labeled coloums. If you are changing the name of a Pivot
Table
field,
you must typr a new name for the field". Could anyone help me
with
this. I
have changed infor. before but never go this error message.