1. In Col A Row 1, I have input the link that I am going to use:

Value in Col A Row 1: [Test1.xls]Status!$A$30

2. In Col B Row 1, I have created the link using the value in Col A Row 1

Value in Col B Row 1: =Hyperlink(A1)

3. In Col C Row 1, I wanted to capture the values of this worksheet ([Test1.xls]Status!$A$30) but unable to:

Value in Col C Row 1: =A1 ; unable to get the value of $A$30 in status from Test1.xls

4. But if Col C Row 1: =[Test1.xls]Status!$A$30, I am able to get this value.

5. For me, this is not practical to use S/N 4 as the workbook always changes and I will need to update the name of this workbook in Col A Row 1 so that the link is always the latest.

6. Henceforth, pls advice how do I resolve the issue in S/N 3.