Refreshing connected data

I used a query to select and sort data of a worksheet "OriginalData". The query result is shown in another worksheet "Q_OriginalData". When I change or add data in the "OriginalData" worksheet, I want to see them also in the query worksheet. I followed the instructions as given in https://support.office.com/en-us/art...f-c87b9b18c092,

To refresh a specific data connection in the workbook, click a cell in the external data range. On the Data tab, in the Connections group, click the arrow next to Refresh All, and then click Refresh

But without any results. Changes are not shown in the worksheet "Q_OriginalData"

Who can help?

Kind regards

Jan (John)

Hi Tsjallie

I closed the excel file and reopened it, whitout any change in the query data worksheet "Q_OriginalData".

Kind regards

Jan

I will do that, but not earlier then next week.

Kind regards


Jan

Hi Tsjallie

Here is the excel file with 2 worksheets, the first one the original and the second one the query sheet. In the original sheet I added already two records/rows with AAAtest(). After update the qyuery, the AAAtest should be the first recond/row in the second worksheet.
I hope you can help me.

Kind regards

Jan

sorry, I forgot the file. How do I upload this?

It took a while, but the file is attached now.

Jan

Hi Tsjallie

Thanks a lot. It works!

I changed also the absolute file reference c:\users\jan\desktop\bibliotheek_v1.xlsm into bibliotheek_v1.xlsm. But that was not accepted. Is there a possibility to use a relatief refence to the file used?

Kind regards

Jan