| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query via Import External Data doesn't reflect revised syntax
Query can be edited (a hard coded date filter) and the result is correct when
previewing (via Query Now). But after saving the query, when the query is refreshed (via Refresh Data), the query reflects the OLD date filter. But, if the exact same query is re-linked to Excel (via DataImport External DataImport Data), the revised hard coded date filter is used. How can the same query definition (xxx.dqy) have different versions based on when it was linked to Excel? What needs to be done to get a query that has already been linked to Excel to use the most recent version of the syntax? (The only way I have found to get the query to use the REVISED syntax is to add a new worksheet and relink the query via DataImport External DataImport Data.) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tool bar: Data/Import external data/New database query | Setting up and Configuration of Excel | |||
| Import external data - web query | Excel Discussion (Misc queries) | |||
| Import Data -- External Web Query | Excel Worksheet Functions | |||
| How to do Edit Query from Import External Data. | Excel Discussion (Misc queries) | |||
| Import External Data/New WEB Query | Excel Discussion (Misc queries) | |||
Threaded Mode
