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