Column limit for Pivot Table data source

  • Thread starter Thread starter Yoam69
  • Start date Start date
Y

Yoam69

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.
 
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.
 
Back
Top