Forum Discussion

adriana73's avatar
adriana73
Copper Contributor
Apr 17, 2020

Pivot creation

Hi, it's my first time here!

I have a very basic issue in creating a pivot in excel. I select data rows and column, click on insert a pivot, and I can't go ahead as it appears an error message:

 

 

It seams that the field name of the pivot is not valid but I dont' understand why...

 

It will appear to most of you as a "silly" question....but for me it's a big problem now and hope someone can help me 🙂

Thanks

 

Formulas and Functions

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 18, 2020

    adriana73 The source data is set to span columns A to T, but the picture doesn't show what's in T. Does it contain data? Does it have a header? Is it perhaps hidden? Columns without headers or empty columns are not permitted.