What version of Excel are you using?
Did you create one pivot table and then base all the others on that
pivot table?

If each pivot table is based on the source data, and has a separate
pivot cache, that will slow things down. You could use the sample code
here, to set all the pivot tables to the same pivot cache:

http://www.contextures.com/xlPivot11.html

Test on a copy of your workbook, and see if it helps.

Pivot Tables wrote:
how do i limit the amount of time it takes to refresh a pivot table from an
excel file that has about 30,000 rows of data? I have about 100 pivot tables
that all feed from the same excel data file and it takes about 2 minutes to
refresh each pivot. Is there a solution out there that could limit the time
of refreshing?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html