Excel 2007 external data query
1. I have an query that i want to add parameters to, where in 2007 do i do
that? the parameters come cells as opposed to prompts.
2. My query is something like Select Count(fld1) as Counter from sometable
when the data is returned to excel in 1 cell how do i get rid of the Filter
drop down that appears above the 1 value that is returned?
OR must i do a vba query to accomplish the above?
|