Simple hyperlink question

[StewartS]

I have been asked by a colleague how to insert a hyperlink from one workbook to a specific sheet in another workook. I have looked through the site and it appears that the details are
\\w2k3-bsp1\Data\HRDATA\MA\StewartS\TEST\BLIB O12 Account Analysis full Download Check.xlsx - 'sheet4'!a1
but when I try it I get the message Cannot open the specified file. I assume it is something to do with the way the sheet details are shown. Can anybody help please.

Thanks

StewartS

 

[Msxluser]

Hi,
Use this =HYPERLINK("[w2k3-bsp1\Data\HRDATA\MA\StewartS\TEST\BLIB O12 Account Analysis full Download Check.xlsx]sheet4!A1","CLICK")

 

[StewartS]

Wecome to the board and thanks I just needed to add \\ in front of the w2k3 to pick up the network drive.

 

[Msxluser]

Hi,
Use this =HYPERLINK("[\\w2k3-bsp1\Data\HRDATA\MA\StewartS\TEST\BLIB O12 Account Analysis full Download Check.xlsx]sheet4!A1","CLICK")