Recently doing some EXCEL and ACCESS the data link between the applications, there is a problem still cannot solve, ask everybody to help, thank you,

I created a sheet in an EXCEL, and then recorded some data, such as data. XLSM sheet1 inside.

Then I create a access files, dynamic data in a read sheet1, then after some filter conditions, generating a query query1.

Inside. And then I in data XLSM create a sheet2, dynamic import query1, according to the data inside the

My idea is that modify the data in the sheet1, sheet2 will automatically update the data,

The problem is, every time the refresh data in the sheet2, will be submitted to the data link failure,

To check this link, I in data XLSM select [data] - [connections], and then select the data link, and then click [refresh], found an error, what data link error,


If I create a new excel, such as data1. XLSM, and then create a sheet to read the data in the query1, there is no any problem,

I want to ask you, can't read and write the same excel file? Means that data link cannot be a closed loop, right? Thank you very much!