Thanks Tom

Spot on as ever!!

I've never used Knowledge base for Excel problems. Do you
find it a useful source?

Thanks again


-----Original Message-----
There are other limits as well:

http://support.microsoft.com/?kbid=157486
XL97: Limits of PivotTables in Microsoft Excel 97
(Q157486)

http://support.microsoft.com/?kbid=211517
XL2000: Limits of PivotTables in Microsoft Excel 2000
(Q211517)

http://support.microsoft.com/?kbid=291061
XL2002: Limits of PivotTables in Microsoft Excel 2002
(Q291061)

--
Regards,
Tom Ogilvy


"Barry" wrote in message
...
Hi

I'm using a pivot table with quite a large amount of
data. When I try and add a 5 field it tells me that I
can't add any more and must remove one of the existing
ones before I can add a new one. I checked the specs
and
pivot tables only seem to be constrained by memory. I
checked the memory usage through Task manager and it
doesn't seem very high?

Has anyone got any ideas?

Thanks in advance

Barry



.