Error: Can't open specified file when clicking a hyperlink formula to a location in the same workbook

[Engineer Joe]

I'm using the following formula:

=HYPERLINK('STW Lin Acc Upgrade'!F16,[Project Number:])

Whenever I click the cell, I get a pop-up error message reading "can't open the specified file." The thing is, I'm not linking to another file. I'm just linking to a cell in another worksheet in the same workbook. Anyone know why this is happening?

 

[MrTeeny]

Think I got the wrong end of the stick

 

[MrTeeny]

You'd need to add # to the sheet name to specify it's within the same workbook


try

=HYPERLINK("#'STW Lin Acc Upgrade'!F16","[Project Number:]")