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.