Internal Hyperlinks in Excel File Stored on Network Drive

[pelya]

Hello,
I am having trouble creating a hyperlink to a place in the current document for a file stored on a network drive. My workbook has a lot of sheets (50 or so), so I created a 'Navigation' sheet that contains hyperlinks to all the worksheets located therein, and pasted a link back to the Navigation sheet in cell A1 on every tab.

Setting up these Navigation sheets has never a problem until I started posting the file on a network drive. As soon as I did that, I noticed that the internal hyperlinks on all sheets in the workbook would stop working after I closed the file in Excel. Note that this network drive is not set as a drive letter on my computer, and is only accessible by entering the server ip address in Windows Explorer.

An example address the hyper is trying (and failing) to open is: "file:///\\ IP ADDRESS \ sub-folders \ activefile.xlsm"

I've tried a few options, using the HYPERLINK formula, using the HYPERLINK feature in the Insert ribbon, etc, but all to no avail.

Any suggestions is greatly appreciated!

 

[pelya]

.

 

[pelya]

.

 

[pelya]

.

 

[pelya]

.

 

[Andrew Poulsom]

Welcome to MrExcel.

In the HYPERLINK function you can use # instead of the path, eg:

=HYPERLINK("#Sheet2!A1")

 

[pelya]

Thanks Andrew! I ended up changing the formula slightly, to account for worksheets that had spaces in the worksheet name.

=HYPERLINK("#'Sheet2'!A1")

 

[Andrew Poulsom]

In that case you need to surround the sheet name with single quotes, eg:

=HYPERLINK("#'Sheet 2'!A1")

 

[pelya]

Thank you!