worksheet in different folder cannot be linked
Answers
Answered by
3
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:
Similar questions