Column limit for Pivot Table data source
 

Is there a limit for the number of columns in a data source for a pivot table
in Excel 2007? My data source is a table object with 80 columns. I can
create a pivot table for the data, but upon trying to refresh it tell me
there is too much data.

If I reduce the columns by exactly 1, it works fine...limit of 79...very odd
number.

Column limit for Pivot Table data source
 

There doesn't seem to be.

Put:-

EXCEL Specifications And Limits

- into the F1 Search Facility.

In the above topic there is a section called:-

PivotTable and PivotChart report specifcations and limits

Your specific question is not covered in the above topic.

If my comments have helped please hit Yes.

Thanks.

"Yoam69" wrote:

Is there a limit for the number of columns in a data source for a pivot table
in Excel 2007? My data source is a table object with 80 columns. I can
create a pivot table for the data, but upon trying to refresh it tell me
there is too much data.

If I reduce the columns by exactly 1, it works fine...limit of 79...very odd
number.