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

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

Yes.

If you go into ToolsOptionsEdit and uncheck "edit directly in cell".

Now double-click on the cell with the formula to jump to the source worksheet.

Or open the source workbook if that is what you mean.


Gord Dibben MS Excel MVP



On Wed, 15 Nov 2006 12:59:02 -0800, 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