Query via Import External Data doesn't reflect revised syntax

M

Melanie

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 Data>Import External
Data>Import 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 Data>Import External Data>Import Data.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query to import from Sharepoint 0
Import External Data 3
Import external data into Excel 0
Import Data from Access query 8
Import External Data Problem 0
Import External Data not picking up letters 2
Data Import into Excel 3
Ms query and Excel 0

Top