I have problem with slow PIVOT CHART form

S

skywalker103

Hello all

I have realy big problem. I have txt file linked as linked table to my mdb
database. This table can contain aproximatelly 1 000 000 records
(teoretically), but real count is 100-500 000 records. I have based Pivot
chart on this table, but it takes maybe 2 minutes until data are accessed and
prepared. Then it takes more then 3 minutes to refresh data according user
selection. This table is STAND ALONE, without relations to other table. Is
there any possibility to speed up this PIVOT Chart routines and problem?
Please help me, I have no idea what to do...
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
A list and chart from two pivot tables 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Use form to open pivot chart 0
Combining of non-specified items into single group in Pivot chart 1
Pivot Chart in Access Form not working 0
Pivot Chart Header 0

Top