I'm trying to create a hyperlink that takes a user to a specific cell (or range of cells) in an external workbook, and I've run into bit of a roadblock. I've discovered that using the method:
=HYPERLINK("[\\server\folder....\file.xls]worksheet!range","message")
works just fine as long as there are no spaces in the worksheet name. Unfortunately I am trying to link to an external worksheet with spaces in the name (which I am not allowed to edit).
Does anyone know of any syntax that will remedy this problem?
Thanks much,
Scott
Bookmarks