Slow pivot table- update faster

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.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
That's not a particularly big dataset so I am surprised it is taking so long. If you remove the data fields and then add the row fields (before finally adding the data fields again) does it speed up? You could alternatively use code to add the fields which could be quicker as you can prevent the pivot table from updating after the addition of each field.
 
Upvote 0
Thank you for the suggestions. I copied the pivot table sheet to a new workbook and saved as .xlsx. The original file is in .xlsb format. I wonder if that made the difference? It's much faster now.
 
Upvote 0

Forum statistics

Threads
1,216,762
Messages
6,132,574
Members
449,737
Latest member
naes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top