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?