correct workbook in the cell C2, to get the value of correct answers marked by Anand.
How to Create External References in Excel? Instead of having a large sum of data in a single worksheet, we can have our dashboard or report in one workbook.
Opened the destination file and observed the linked data.Closed and re-started Excel to ensure all new settings are effective.Opened the source file, modified the data, saved and closed the file.
This behavior was observed in version 1907 of Excel from the Office 365 software package. SECURITY WARNING Links to external sources could be unsafe. Excel Security Warning About Linked WorkbooksĪfter linking two local Excel files by a simple reference to a cell in another workbook, I began seeing an ominous error: