How to link, link data between Excel files

When using Excel, there are cases where the data resides in different Excel files, and you need to get data from one Excel spreadsheet to another. So you have to create data links between Excel files so that data can be transferred automatically.

How to link, link data between Excel files Picture 1

Consider for example: There are two inventories in 2018 and 2019, the inventory at the end of 2018 is the inventory at the beginning of 2019. So how does the inventory data at the end of 2018 turn to inventory in 2019?

How to link, link data between Excel files Picture 2

Step 1: First you have to get the path address, here is to get the address of the warehouse file in 2018 by right-clicking on the file list of warehouses in 2018 (1) , selecting Properties (2) .

How to link, link data between Excel files Picture 3

Properties window appears, highlight (select) the location of the file in the Location section . Select Copy and then click the OK button to close the window.

How to link, link data between Excel files Picture 4

Step 2: Open the destination file to retrieve data from the inventory in 2019 , click on the cell to retrieve data, type an equal sign + a comma (= '), and then paste the address.

How to link, link data between Excel files Picture 5

Step 3: Add detailed address information including file name + Sheet name + Cell location containing the original data by the syntax: [ file.xlsx name ] sheet name ! cell address . Of which: the red characters are fixed, the content in bold you change in accordance with your report.

How to link, link data between Excel files Picture 6

Step 4: Press Enter to see results.

How to link, link data between Excel files Picture 7

Note:

- The data link does not automatically update if you do not open the original and target data files simultaneously. So when opening the destination file, Excel will notify you of the update, press the Update button so that Excel automatically updates the data without opening the original file.

How to link, link data between Excel files Picture 8

Above Software Tips guide you how to link data between files in Excel. Good luck!