Max columns in a pivot table (Excel 97 SR-2)

Topic

New Reply

Is there a maximum number of columns allowed in a pivot table?

I am tracking response levels from a TV message and have a number of fields that I would like to analyze and trend on a weekly basis. The messages aired every week during the year. I need to do a trending over a full year (i.e. 52 weeks) but by pivot table stops at 51 weeks plus the total column.

Any help would be appreciated.

Thanks
JB

Reply | Quote

Replies

JB,

Yes there is. See the Microsoft knowledge base articles:

“Limits of PivotTables in Microsoft Excel…”
Q157486 – XL 97
Q211517 – XL 2000

If you are using Internet Explorer you can go directly to the articles by
just entering the following in the address bar: mskb Q157486

Regards,

Jim Cone
San Jose, CA

Reply | Quote