#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 747
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Data Adding contents of two pivot tables and param que Roundy Excel Discussion (Misc queries) 0 July 2nd 07 10:20 PM
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel westy Excel Worksheet Functions 5 March 10th 07 01:31 AM
Pivot Tables -changing datasource for exsting Pivot Table kfschaefer Setting up and Configuration of Excel 0 May 30th 06 06:36 PM
Can links between Excel 2003 Pivot Charts and their pivot table b. Mark Allen Charts and Charting in Excel 2 March 5th 05 05:24 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 01:34 AM


All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"