Excel Chimp
Board Regular
- Joined
- Oct 30, 2008
- Messages
- 90
I have a pivot table with 47 fields to choose from. I'm adding these to the row section of the PT. Each time I add a field it is taking forever (calculating...).
The source data is on a separate worksheet and is values-only, which I thought might help but apparently not.
The source data contains about 11,000 total cells of data.
Any suggestions?
Thanks.
The source data is on a separate worksheet and is values-only, which I thought might help but apparently not.
The source data contains about 11,000 total cells of data.
Any suggestions?
Thanks.