Using MSQuery for Excel, I have created a query linked to an outside data
source that uses a parameter that is linked (auto-prompted) to a cell on my
worksheet. That works very well. Now I want to group the rows (within the
query) and sum the values. This doesn't work!

However, it does work for me as long as I supply the parameter within the
query grid. However, if I want it to prompt me for the parameter, it gives me
the error.. "Invalid column name 'mydata'. Statement(s) could not be
prepared."

Why is it doing this? And.. How can I get around it???
--
Thanks! cs