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