You can use the HYPERLINK function or else you can use the menus:
Insert--Hyperlink. If you use the latter method, you want to select workbook
hyperlinks, not internet hyperlinks from the dialog box. The advantage to
using the menus is that the dialog box makes it clear what to choose. I find
the syntax of the HYPERLINK function confusing to remember.

Dave
--
Brevity is the soul of wit.


"Dinesh" wrote:

Is there a function in an excel where you double click the formula which is
linked to another worksheet and it open the worksheet automatically?

Thanks to let me know.

Dinesh