ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pivot (https://www.excelbanter.com/excel-discussion-misc-queries/208907-pivot.html)

Sujatha Sarma

pivot
 
I am not able to create a pivot table - error message is appearing saying
that pivot table field name is not valid. it also, says, to create a pivot
table, you must use data that is organised as a list with labeled columns, if
you are changing the name of a pivot table field, you must type a a new name
for the field. I dont know where is the issue - my data has all the colmuns
labled. i am stuck up.

muddan madhu

pivot
 
check it here

http://support.microsoft.com/kb/213955


On Nov 4, 4:35*pm, Sujatha Sarma <Sujatha
wrote:
I am not able to create a pivot table *- error message is appearing saying
that pivot table field name is not valid. it also, says, to create a pivot
table, you must use data that is organised as a list with labeled columns, if
you are changing the name of a pivot table field, you must type a a new name
for the field. I dont know where is the issue - my data has all the colmuns
labled. i am stuck up.



Debra Dalgleish

pivot
 
Maybe there's a hidden column that's blank, or the pivot table range
includes an extra column beyond the headings.

Sujatha Sarma wrote:
I am not able to create a pivot table - error message is appearing saying
that pivot table field name is not valid. it also, says, to create a pivot
table, you must use data that is organised as a list with labeled columns, if
you are changing the name of a pivot table field, you must type a a new name
for the field. I dont know where is the issue - my data has all the colmuns
labled. i am stuck up.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com



All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com