software

I don't know whether there's a limit on the number of columns of input...
but the resulting table has to fit in the 256-column limit of any Excel
sheet. If you've got 16 columns of input, presumable with varying
combinations, you're likely to hit that hard ceiling. If you don't have a
lot of different combinations that are actually used in the data, it may help
a bit to not put subtotals on the table rows, but that's not likely to make a
huge difference.

quot;Socal Tomquot; wrote:

gt; When I am trying to create a pivot table, I have about 16 colums of data that
gt; range from data and colums that have numbers.
gt;
gt; I do get a popup error telling to delete one or two columns of data to make
gt; the pivot table work.
gt;
gt; Is there a limited number of columns that a pivot table can use?