Hyperlink function "reference is not valid" when refering to another sheet in same file

Hi,

In the attached file, in sheet 01 cell A1 I have put a hyperlink function as so:

=HYPERLINK( TEXT("#'A'!B" & MID(CELL("filename",B1),FIND("]",CELL("filename"),1)+1,5)+2, "General"), "Go To A")

There is only two sheets in the file attached, the main sheet A and the sub sheet 01. I'm planning on using this formula for multiple sheets and it suppose to behave following the name of the current sheet where the hyperlink function is placed. If the sheet's name is 01 it will go to cell B3 in the main sheet A. If it is named 02 it will go to cell B4 in the main sheet A and so on and so forth.

But the problem is, though the formula :

=TEXT("#'A'!B" & MID(CELL("filename",B1),FIND("]",CELL("filename"),1)+1,5)+2, "General")

Resulted in:

#'A'!B3

as tested in sheet 01 cell B3. When I click the hyperlink it still says "Reference is not valid". I tried using just 1 ' and tried without any '. It still says "Reference is not valid". Can somebody point me where my mistake is??

Regards

Yesss! that was the problem, I still had the original hyperlink in that cell that i put using CTRL+K. I had to remove it by clicking "Remove Link" and then the rest is history. Solved! Thank you!

N.B. Thanks for the extra input. But I decided that I wanted to go with my original formula because it doesn't have to depend on the value at B1 instead.

I'm a bit curious though, is there anyway to compare which one actually works better when you click it? I mean, is there any method to calculate which one is actually faster when in operation? The method should be able to calculate each operation in miliseconds or even smaller perhaps.