Column limit for Pivot Table data source

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.
 
T

trip_to_tokyo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top