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


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=150834

Microsoft Office Help