View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot Table refresh error

The limitations for pivot tables in Excel 2000 are much lower than those
in Excel 2003, so that's the issue.

These MSKB articles outline the limits for Excel 2000 and Excel 2003:

2003 -- Description of the limits of PivotTable reports in Excel
http://support.microsoft.com/kb/820742/

2000 -- Limits of PivotTables in Excel
http://support.microsoft.com/kb/211517/

Darby wrote:
I have a pivot table that refreshes fine on my computer but not on a
collegues. He gets an error sying there are too many rows or columns. I
have 6 fields in the row area. I'm on 2003 SP 2 and he is on 2000. Is this
the issue? Or will I get lucky and find an easier fix?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html