Speed up Pivot table Refresh time

MikeGeno

Board Regular
Joined
Apr 4, 2008
Messages
130
I have a workbook with a sales data tab that is 9 columns by 340,000 rows. I have 4 pivot tables all linked to the same data. 3 of the pivots refresh almost instantly as they do not drill down to the lowest level of detail. The last pivot I am including the customer, and city, state and this one for some reason refreshes excruciatingly slow (4-5 minutes) Once I added the customer field it slowed to a crawl. There are many thousands of unique customer names in the data.

I have looked for VBA code to help speed this up but cannot seem to find anything that works. Any help is greatly appreciated.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,102,332
Messages
5,486,211
Members
407,537
Latest member
Frank Nunez

This Week's Hot Topics

Top