Pivot table column limits
See "Excel Specifications and limits" for more detailed info. Your actual
column count is only limited by memory. However, you are limited to 256 page
& data fields. Note that Standard XL only has 256 columns, so if you try to
exceed that, XL will spit a warning at you, and only display part of your
PivotTable.
Bottom line:
With only 40, you should be fine.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"TJ Dowling" wrote:
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
|