Trying to update External closed workbook link

[ExcelNewbie_2023]

Trying to update the link automatically based off of values of $B$1&B4&$B$2. The issues is it gives me the text as the result instead of establishing the link. If I copy and past Values and add an = sign to the front of the text it will establish the link. What can I do to make this work automatically?

 

[OaklandJim]

Have you tried the Hyperlink function? If I understand your need that is what you should use.

Book1
	A	B	C	D	E	F
1	Link Part 1	https://www.mrexcel.com/
2	Link Part 2	board/help/xl2bb/
3
4		https://www.mrexcel.com/board/help/xl2bb/
Sheet1

Cell Formulas
Range	Formula
B4	B4	=HYPERLINK(B1&B2)

 

[ExcelNewbie_2023]

Have you tried the Hyperlink function? If I understand your need that is what you should use.

Book1
	A	B	C	D	E	F
1	Link Part 1	https://www.mrexcel.com/
2	Link Part 2	board/help/xl2bb/
3
4		https://www.mrexcel.com/board/help/xl2bb/
Sheet1

Cell Formulas
Range	Formula
B4	B4	=HYPERLINK(B1&B2)

I am using hyperlinks to be able to go to the document. What I am trying to do is pull cell values into the current workbook from the external workbook. This can be done with an INDIRECT function but that only works if the external workbook is open. I am trying to figure out a way to do it with a closed external workbook.

If you look at cell C4, that is the link + look up cells that when typed directly into the formula bar as in D4 pulls in the value of the cell F15 of the closed workbook.