Hi Debra

Thank you for your quick reply, however, every heading cell does actually
contain a heading, all formatted identical. Any more ideas??

Thanks again.

Louise

"Debra Dalgleish" wrote:

One or more of the heading cells may be blank, and to create a pivot
table you need a heading for each column.

Louise wrote:
Can anybody give me some advice regarding pivot tables?

I create numerous pivot tables, usually without a problem, however, I have
recently tried to create a pivot table from a worksheet and when you get to
Step 2 of the Wizard - asking you for the range of cells - it picks up the
table but omits the headings at the top. If I then change the range myself
to include row 1, when I get to the end of the Wizard, it says 'the pivot
table name is not valid'? and will not let me create it.

Has anybody come across this problem before or know how I can get around it?
Any urgent help would be appreciated.

Thank you.

Louise


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html