How to get data from another Excel not by PowerQuery

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
670
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.
Thanks
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,186
maybe a simple query - and set it to refresh on file open. requires no code. can set up via ALT-D-D-N then follow the wizard
 

Forum statistics

Threads
1,077,618
Messages
5,335,267
Members
399,009
Latest member
twcaddell

Some videos you may like

This Week's Hot Topics

Top