http://support.microsoft.com/default.aspx?scid=kb;EN-US;291061
XL2002: Limits of PivotTables in Microsoft Excel 2002
http://support.microsoft.com/default.aspx?scid=kb;EN-US;211517
XL2000: Limits of PivotTables in Microsoft Excel 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;157486
XL97: Limits of PivotTables in Microsoft Excel 97
http://support.microsoft.com/default.aspx?scid=kb;EN-US;197331
Excel for Macintosh: Limits of Pivot Tables
I believe they all pretty much say the same thing.
Regards,
Tom Ogilvy
Quote:
> I'm having problems with a pivot table which refuses to refresh as Excel
> says there are too many columns showing andg prompts me to hide some of
> them. However I need to see them all. How can I solve this problem ? Is
> there a threshold above which Excel sends this message ?