Pivot Table slow when changing

J

jireland

I created a pivot table that is linked to a large Access
table (over 300,000 records). When I make changes to the
pivot table it takes a long time to update. I would like
to quickly be able to look at the data in different ways.
Is there any way to speed up the pivot table, or will it
always be slow because of the large amount of data it is
manipulating?
 
F

Frank Kabel

Hi
if you're processing 300,000 records no wonder this is slow. Besides
getting a faster machine I don't think you can get it faster.

You may consider defining some queries in MS Access and use these
queries as source four your pivot table. The queries may be able to
reduce the number of records processed
 
Top