Hi All.
I have two excel files, one supposed to pull data out of the other one, but the source file might be open.
There was a way in Power Query (if I remember correctly) that if I only created a connection and added the data to the Data Model the the query would only open the source file in...