Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
deniseh
 
Posts: n/a
Default The Pivot Table field name is not valid,

I am receiving the above error message, but don't understand why. My data is
in columns, organised as a list and the columns are labelled. What do I have
to do to get over this?
Thanks
Denise
  #2   Report Post  
Joe Mac
 
Posts: n/a
Default The Pivot Table field name is not valid,

Hey Deniseh...

The Pivot table is looking for a concentric group of columns and cells, my
belief without seeing the data is that you have a column in the data range
that does not have heading... check to verify that each the first cell in
each column of the pivot table data range has a value populated
--
Thanks for your help -
Joe Mac


"deniseh" wrote:

I am receiving the above error message, but don't understand why. My data is
in columns, organised as a list and the columns are labelled. What do I have
to do to get over this?
Thanks
Denise

  #3   Report Post  
deniseh
 
Posts: n/a
Default The Pivot Table field name is not valid,

Thanks Joe, it worked first time when I realised there were hidden columns,
your help is very much appreciated. It'll save hours of work!!!!!
Regards
Denise

"Joe Mac" wrote:

Hey Deniseh...

The Pivot table is looking for a concentric group of columns and cells, my
belief without seeing the data is that you have a column in the data range
that does not have heading... check to verify that each the first cell in
each column of the pivot table data range has a value populated
--
Thanks for your help -
Joe Mac


"deniseh" wrote:

I am receiving the above error message, but don't understand why. My data is
in columns, organised as a list and the columns are labelled. What do I have
to do to get over this?
Thanks
Denise

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
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 06:32 PM
The Pivot Table field name is not valid, deniseh Excel Discussion (Misc queries) 1 October 21st 05 01:21 PM
How to get pivot table Time field to appear correctly wccmgr Excel Worksheet Functions 1 August 23rd 05 12:26 AM
How can I show all field data in a pivot table, instead of blank Alastair Scott Excel Discussion (Misc queries) 3 August 17th 05 07:08 PM
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 28th 05 12:25 AM


All times are GMT +1. The time now is 01:37 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"