View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yoam69 Yoam69 is offline
external usenet poster
 
Posts: 13
Default 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.