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?