Excel- Link to Hyperlink Separate Worksheets

[jacksum336]

Hello,

In the same workbook, I am trying to reference a cell on a separate worksheet.
On Sheet 1, Cell A2, I want to reference Sheet 2, Cell A7. Cell A7 is a hyperlink that opens up a worksheet within the workbook.

I have tried =(hyperlink(Sheet2!A7,"Link"). However, I get the error message, cannot open file specified.
Thank you.

 

[Joe4]

Duplicate: Hyperlinks and VLOOKUP Error

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rules # 9 here: Forum Rules).