Thread: Hyperlink Function to External Workbooks

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

Add single quotes:

=HYPERLINK("[\\server\folder....\file.xls]'my worksheet'!range", "message")