Create hyperlink without filename?

[robotman]

1) Is there a way to create a hyperlink that just references the sheet
and cell you want to jump to within the same workbook? i.e.:

'sheet1'!A1

When I go through the "add hyperlink" option and choose "place in
workbook," it adds the whole file name to the hyperlink: i.e.

file:///\\server1\folder\myfilename.xls - 'sheet1'A1

2) Is there a way to directly edit the hyperlink address so I can
delete the file name?

Thanks.

John

 

[Gord Dibben]

Why do you wish to do this?

A workaround is to add a screen tip when creating the Hyperlink or when editing
it.

Just type whatever you want to see when you hover.

Could be the sheetname or "click me to jump to Sheet4"


Gord Dibben MS Excel MVP

 

[robotman]

My main question is can I specify a hyperlink without the file name.
I don't care too much what it says when someone hovers over it.

The problem I'm having is that different people have different letters
mapped to the same networked files so the hyperlinks breaks when files
are shared. If I can just specify a sheetname!cellreference as the
hyperlink, it seems like this would fix the problem.

And I was wondering if there is a way to edit the hyperlink address
directly? (which would potentially solve my problem, too).

Thanks.

John

 

[Gord Dibben]

If you are just hyperlinking to another sheet in the same workbook, there should
be no path or filename involved.

Insert>Hyperlink>Place in this document. Select a sheetname and OK

The hyperlink just shows the sheetname!cellref

I know of no way to change Excel's default of inserting the full path in a
hyperlink to another workbook or other external source.

Hang in, there are many others that have greater knowledge than myself.


Gord

 

[robotman]

Insert>Hyperlink>Place in this document. Select a sheetname and OK

The hyperlink just shows the sheetname!cellref

This is exactly what I am doing, except I get the full file name of
the workbook added to the hyperlink. I want it to just use the
sheetname!cellref. I'm placing it in the workbook, not referecing an
external workbook.

Any ideas on what's going on?