Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table column limits
Hi,
First, I assume you mean how many column of data in the raw data, not how many column can be output to the display? Second, Specifications doesn't address the number of fields in the source range. What it says is that the number of column fields in the pivot table report is only limited by available memory. Third, If you are talking about how many field in the raw data, the answer is version dependent. 2003 and earlier have only 256 column in a sheet, 2007 has 16,384 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
row limits excel 2007 restricting pivot table calculations | Excel Discussion (Misc queries) | |||
Limits of Pivot chart | Charts and Charting in Excel | |||
pivot dropdown list limits | Excel Discussion (Misc queries) | |||
Pivot table Limits? | Excel Discussion (Misc queries) | |||
Pivot table limits | Excel Worksheet Functions |