How to link data between excel files together

In the course of using Excel, you may need to use data from one file to another quickly, but the data changes are still updated by linking links between data files. how to practice? Let's find out through the article below.

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

- Step 1 : Open 2 excel file

How to link data between excel files together Picture 1

How to link data between excel files together Picture 2

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

How to link data between excel files together Picture 3

- Step 3 : copy the Location link, click OK

How to link data between excel files together Picture 4

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

How to link data between excel files together Picture 5

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

How to link data between excel files together Picture 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 on the data box as shown below

How to link data between excel files together Picture 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

How to link data between excel files together Picture 8

- Press Enter to see results