Using MS Query with Access and Excel at once time

[Roberta]

I have a co-worker who is using the MS Query to access an
Access table but want the look-up or parameter query to be
based on a range of cells in Excel. He tries to use the
MS Query but it is grayed out.