Pivot Table slow when changing

  • Thread starter Thread starter jireland
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table - Changes 5
Adding to an existing Pivot Table 7
Question on the occupied field of the pivot table in excel spreadsheet 0
Issue with pivot table 1
Easy way to change Pivot table source files? 5
Pivot Table date format 1
Are copied Pivot Tables "linked" to each other ? 2

Back
Top