O
omegared
Hi
I have some tables in various xl files, call the files a,b and c. I
want to import all these into a single xl file called e. If changes
are made to a,b or c I want it to automatically update e.
I have used the import function in d but if I change a,b or c to see
the change I have to select the data in d and press refresh.
Furthermore when I refresh d i have to have files a,b and c open
otherwise it says connection lossed and is unable to refresh the data.
Can someone explain to me in simple terms what I have to do in order to
get the data automatically updated without having to always keep the
files open and refreshing the data.
Thank you in advance.
I have some tables in various xl files, call the files a,b and c. I
want to import all these into a single xl file called e. If changes
are made to a,b or c I want it to automatically update e.
I have used the import function in d but if I change a,b or c to see
the change I have to select the data in d and press refresh.
Furthermore when I refresh d i have to have files a,b and c open
otherwise it says connection lossed and is unable to refresh the data.
Can someone explain to me in simple terms what I have to do in order to
get the data automatically updated without having to always keep the
files open and refreshing the data.
Thank you in advance.