In the past I recall I can easily link in File 1's range with data from File2's range.
Now I found I can only import from File2 data using powerquery.
Where can I use the old method to link from File2's range so it is dynamic meaning when data in File2's range is changed, File 1 can be updated...