Trying to create external links between 2 workbooks. A range of cells in workbook A, to the same range in workbook B. I've entered the path; '[A.xlsx]PO DATA'!Transaction, "Transaction" is the name of the cells A4:A999. I have also tried using the exact reference of each cell, but when I press enter, the result is not referencing the cell/s in workbook A, only results with the text of the path?
Clearly I'm missing something, please help.
Clearly I'm missing something, please help.