Linking different excel files

New Contributor

HI there


I have two separate excel files that I want to link to a third (two separate budget files for different staff that I want to connect to a third master file). I know how to link an individual cell to another excel file but is there a way of linking a large group of cells to another excel file. My knowledge limits me to having to do it cell by cell at the moment. 


2 Replies
best response confirmed by tour_contact (New Contributor)


Select the source range.

Copy it (Ctrl+C)

Switch to the destination workbook.

Select the top left cell of where you want the links.

Click the lower half of the Paste button on the Home tab of the ribbon, and select Link.

Thanks. Very helpful