How to get data from another Excel not by PowerQuery

mrchonginhk

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

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,264
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,089,662
Messages
5,409,603
Members
403,272
Latest member
user2456

This Week's Hot Topics

Top