We help IT Professionals succeed at work.

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

422 Views
Last Modified: 2012-02-20
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
Comment
Watch Question

Most Valuable Expert 2012
Top Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Anthony MellorPrincipal
CERTIFIED EXPERT

Author

Commented:
Hello Dave, long time no see :-)

Yes did all that. Note; data updates when changed, but not new data appended.

and you mentioned range names not extended (elsewhere):

I have always noticed other system looking type ranges showing in the dialogue box so I didn't define any ranges in the source Excel workbooks and it worked as such.

It updates when changes are within the original regions but doesn't seem to pick up new rows - which is full circle symptom back to data being outside ranges. Having said that when I inserted rows and added data therein it didn't pick that up either. Perplexed here.

I'm  going to re-create it all and check I'm not doing something very daft like appending data to the wrong source file or something although from the above that cannot be.

Anthony
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.