Query Table Performance

[Steve Haack]

All,
I have an Access 2007 Database with about 300,000 recoreds in it. I have
built some queries in the database that will find the recoreds I need VERY
quickly (1-2 seconds to find 12,000-15,000 records, on average).

I am using Excel 2007 to build some charts to reports on the data, so I have
a linked table, which I change the query on, depending on the data that I
want to see.

My problem, is that in Excel, it is taking 5 minutes to update the data when
I change the table to point to a diferent access query and refresh the data.

Can someone point me to some guidance on how to improve this performance in
Excel?

Thanks,
Steve

 

[joel]

It is not the query that uses most of the time, it is the links and th
calculations on the worksheet that uses the most amount of time.
Sometimes can run faster then using links on the worksheet. Yo can us
a Query Update Event to start the macro so it will automatically run

 

[Don Guillett]

Excel is not fond of large external databases