Question

worksheet in different folder cannot be linked

​

Answer 1

Answer:

In Microsoft Excel, you can link a cell in a workbook to another workbook using a formula that references the external workbook. When this link is created, it may use a relative path. With a relative link, you can move the workbooks without breaking the link.  

This article discusses how the references to linked workbooks are stored by Excel in different circumstances

Explanation: