troubleshooting Question

MS Query results do not include source file appended data, why?

Avatar of Anthony Mellor
Anthony MellorFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft ExcelSQL
2 Comments1 Solution474 ViewsLast Modified:
Why might new (appended) entries in an MS Query XLSX source file NOT be refreshing through to the response file?

Changes in the original data DO show through, but new rows do not.

Named ranges are not explicitly involved as I am querying two external files without range names (unlike querying two ranges inside the same file).

I have example files though not sure if I must also upload the query file from deep inside MS folders as well as the two source xlsx files.

It feels like I have to reopen the original query and tell it to refresh or even recreate it. Doubtless recreation would work, but it defeats the objective of fit and forget by which I mean update the two source files and see the results in the response file.

It seems it is intended that these updates should work as I expect
http://office.microsoft.com/en-us/excel-help/use-microsoft-query-to-retrieve-external-data-HA010099664.aspx

and about refreshes
http://office.microsoft.com/en-us/excel-help/refresh-connected-imported-data-HP010087045.aspx?CTT=5&origin=HA010099664



Anthony
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros