External Link

[Bedford]

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.

 

[Anthony47]

Did you use

='[A.xlsx]PO DATA'!transaction

?

 

[Bedford]

Did you use

='[A.xlsx]PO DATA'!transaction

?

Is this VBA?

 

[Bedford]

Is this VBA?

Did you use

='[A.xlsx]PO DATA'!transaction

?

Book 2.xlsx
	A
4	='[2022_Invoice B2C.xlsx]PO DATA'!transaction
PO DATA

 

[Bedford]

Book 2.xlsx
	A
4	='[2022_Invoice B2C.xlsx]PO DATA'!transaction
PO DATA

Did you use

='[A.xlsx]PO DATA'!transaction

?

I only tried the formula; ='[A.xlsx]PO DATA'!transaction

 

[Anthony47]

So Yes, you inserted also "=" to start the formula.

Check if the cell is formatted as text; if Yes then format it "General", then press F2 and Enter to reenter the formula

 

[Bedford]

So Yes, you inserted also "=" to start the formula.

Check if the cell is formatted as text; if Yes then format it "General", then press F2 and Enter to reenter the formula

Yes, I entered it as; ='[2022_Invoice B2C.xlsx]PO DATA'!transaction and the format is text, so set to general, and reentered, it always comes back as; '='[2022_Invoice B2C.xlsx]PO DATA'!transaction, with the the apostrophe before the equal sign?

 

[Anthony47]

Does the file have any macro?

 

[Bedford]

Does the file have any macro?

No macro, I'm not so good with Excel to write macros.

 

[Bedford]

Does the file have any macro?

The source workbook does have data validation in many columns linked to data ranges in another sheet of the same workbook however.