For more information, see the MS article ‘ Create an external reference (link) to a cell range in another workbook’ ='F:\Spreadsheets\Sheet1'!$B$3 ='F:\Spreadsheets\LinkSource.xlsx'!Myrange I’ll cover the usual external links in formulas first, then finish up with the other kinds.Īn external link formula shows the full path to the source if that workbook is closed, otherwise it shows only the workbook name in the path.
There are many options in Excel that control this depending on the kind of link it is.
