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
and about refreshes