Pivot tables

[Barry]

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

 

[Barry]

Thanks Tom

Spot on as ever!!

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

Thanks again