Excel is not fond of large external databases

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve Haack" wrote in message
...
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