<div>
Thank you very much for good tips! I went for nr. 1 and now it works perfectly. <br />
<br />
rgds<br />
<br />
Stayer
</div>


Thank you very much for good tips! I went for nr. 1 and now it works perfectly.

rgds

Stayer

<div>
<div class="content wysiwyg-content">
Hi experts.<br />
<br />
I have created a pivot table from a datasheet form consisting of more than 900 000 rows (very large database). The result is that the performace of the pivot table is poor, for instance sometimes the pivot table opens when clicked while other times it will not open (just begins to load but do not finish loading). This also depends on the computer I use.<br />
<br />
Can anyone suggest me how to improve performance of my pivot table?<br />
<br />
I have been thinking of exporting the datasheet form to excel, make a pivot table in excel and import it back to Access07. Is this &nbsp;possible and will it improve performance?<br />
<br />
Best regards,<br />
<br />
Stayer
</div>
</div>


Hi experts.

I have created a pivot table from a datasheet form consisting of more than 900 000 rows (very large database). The result is that the performace of the pivot table is poor, for instance sometimes the pivot table opens when clicked while other times it will not open (just begins to load but do not finish loading). This also depends on the computer I use.

Can anyone suggest me how to improve performance of my pivot table?

I have been thinking of exporting the datasheet form to excel, make a pivot table in excel and import it back to Access07. Is this  possible and will it improve performance?

Best regards,

Stayer

Improving performance Pivot Table MS Access2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.