Microsoft Excel - Hyperlink to Specific Tab - Asked By Dan on 07-Jan-16 08:29 AM

I am having issues hyperlinking to an Excel 2010 file.

The Excel file is on a sever.

I can open the file thru the hyperlink, but I cannot get it to open to a specific tab in the file.

Here an example of the hyperlink, but it will to go to DCOE tab.

Hyperlink Example: ..........Systems\Training\OJT.xlsx#DCOE!A1

Any ideas why?

V/r

Dan

Hello Dan

Try
..........Systems\Training\OJT.xlsx#'DCOE'!A1

Regards

Harry

Tried that. It does not work. This file is on a server and I am not sure if that is affecting it. I would think not.

Dan

Hello Dan,

In what way does it not work?  Is it the same as before or is there a different fault? I assume that you have the full path to the server in your file address rather than the truncated version from your original post.

Regards

Harry