Link to other Excel documents

When making reports, multiple Excel documents are often used. As you know, data in another worksheet or other document, if it is open, we can easily access by specifying the absolute address of a cell or cell range. But what if we want to access a closed document? And can Excel be used as a data repository? About the link to other Excel files more in the text that follows.

Absolute and relative cell address

Each cell in the table has an address that consists of the name of the row and column in the cross section of which it is located. However, sometimes it is necessary to indicate both a worksheet or a workbook (document), it belongs so that we could use it as an operand in some form. Below it will be the address of the cell address that uniquely determines where it is located.