How to Link Data Between Excel Files Together

This updated guide explains how to Link Data Between Excel Files Together through clear steps, practical examples, and important checks that help prevent common errors.

To get data from one Excel file to another, we need to perform the following 7 steps:

- Step 1 : Open 2 Excel file

Link Data Between Excel Files Together example screenshot 1

Link Data Between Excel Files Together example screenshot 2

- Step 2 : Open the location to save the Excel file to retrieve data (for example, this is Excel file 1). Right-click the file and select properties

Link Data Between Excel Files Together example screenshot 3

- Step 3 : copy the Location link, click OK

Link Data Between Excel Files Together example screenshot 4

- Step 4 : Paste the path into the Excel file to get data

Link Data Between Excel Files Together example screenshot 5

- Step 5 : add Excel file containing the data as shown below

Link Data Between Excel Files Together example screenshot 6

- Step 6 : copy the path = 'C: UsersAdminDesktop [thang3. xslx] Sheet1 ?!. Then go to the Excel file containing the data (namely, Excel file 2). click the data box as shown below

Link Data Between Excel Files Together example screenshot 7

- Step 7 : into the Excel file to get data (Excel file 1) and paste the path = 'C: UsersAdminDesktop [thang3. xslx] Sheet1 ?! as below picture

Link Data Between Excel Files Together example screenshot 8

- Press Enter to see results

social shareand social share

FAQ

What is the easiest way to Link Data Between Excel Files Together?

Start with the requirements in this guide, then follow each step in order. Check the result after every major change so problems are easier to identify.