Link to Excel Sheet

[JLatham]

Visio 2007 Pro.
Trying to get a hyperlink to open an Excel workbook to a specific sheet and
not having any luck. Search for "hyperlink to Excel" here hasn't turned up
anything productive.

Used the hyperlink button from the Borders and Titles shapes and set up the
link to the (locally stored) Excel file. That works fine, but no amount of
futzing with the link seems to get me to a specific sheet in the workbook or
to a cell on a sheet.
Hyperlink as
C:\SubFolder1\SubFolder2\ExcelWB.xls
works fine, but when edited to neither
C:\SubFolder1\SubFolder2\ExcelWB.xls#'1'
(where the sheet tab name is the digit 1)
nor
C:\SubFolder1\SubFolder2\ExcelWB.xls#'1'!C4
works. The file opens but I get a "Reference is not Valid" error message in
Excel. These formats works just fine from Word and other documents, but not
from Visio.

Is it possible to link to a specific location (worksheet or worksheet and
cell address) in Excel from Visio, and if it is, how do I set up the
hyperlink to get the job done?

Any help is very much appreciated.

 

[AlEdlund]

I tried this format

C:\SubFolder1\SubFolder2\ExcelWB.xls#1!C4

instead of your

C:\SubFolder1\SubFolder2\ExcelWB.xls#'1'!C4

and it worked fine for me,

al

 

[JLatham]

Unbelievable - I'll give that a try without the single quotes. Somehow I'm
betting it will work just fine. I'm so used to using them, and the MSFT
Examples I did find used them, so I took it as gospel that they were needed.

Many thanks.

 

[JLatham]

Oh, yeah, and I tested it and it worked like a Champ!

 

[JLatham]

Al,
I thought I'd pass along a little more information about this that I
discovered. As I said earlier, your solution worked great.

I decided to test it with a sheet name that contained spaces, such as [A
Sheet Name]. That failed with the "Invalid Reference" error on the Excel
side. So I went back to my previously not-working way of setting up the link
with single quote marks, and lo-and-behold, that worked.

A hyperlink like
O:\folder\excelfile.xls#A Sheet Name
or
O:\folder\excelfile.xls#A Sheet Name!C4
both fail, but when changed to enclose the sheet name with single quotes, as
'A Sheet Name' they both work properly, and as expected/hoped for.

Seems we have a rule:
For worksheets with no spaces in the sheet name, no single quote marks
required (even to the point that they must be excluded), but
for worksheets with spaces in the sheet name, the name must be enclosed in
the single quote marks.

Hope this helps in providing help to others in the future.

JLatham of the Excel group.

 

[assagai]

guys,
I’ve been struggling with this issue for a long time and cannot find a
solution
I created a simple test doc and a hyperlink to it C:\test.xlsx#a!A1
As expected it opens with focus on first cell of sheet “a†from MS Word
document
My objective is make it work in Microsoft Outlook 2007 (mainly form tasks)
I’ve copied the whole link and it does not work. I mean the book opens all
right. But it opens with focus at the last sheet it was closed. It ignores
the sheet instructions completely
I’ve tried different syntaxes with no success:
With quotes or without, with “=†sign or without
Any ideas?

 

[JLatham]

assagai,
Your answer may come from the Outlook group
http://www.microsoft.com/office/com...icrosoft.public.outlook.general&lang=en&cr=US
better and faster than from in here.

I asked in this forum because this is where those who work with Visio every
day hang out (just as I help out in the Excel forums as much as I can) ... So
I think that your answer will have a better chance of getting answered
properly in that forum, but I'll ask if you've tried the hyperlink to it as
c:\test.xlsx\'a'!A1
or not, note the single quote marks around the sheet name. That may help,
may break it worse than it already is, but can't hurt to try.