I am trying to create a pivot table.

the data comes from 14 seperate sheets from one workbook.

However i want the column headers to act as field names but it only allows 4?

is it possible to change this or creat the pivot in a different way.

its so annoying!!!

Cheers for reading my thread