View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TJ Dowling TJ Dowling is offline
external usenet poster
 
Posts: 7
Default Pivot table column limits

Does anyone know the limit to the number of columns that a pivot table can be
created from?

I'm working on some requirements for pivot tables and it looks like I will
have at least 40 columns that could potentially be in the pivot table. Since
I've never built one that large (and don't actually have enough data to build
a test), I wanted to know if there is a physical limit to the pivot table.

Thanks,
TJD4