| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Service error "cannot connect to external data source" | Excel Discussion (Misc queries) | |||
| Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
Linear Mode
