Hyperlink to Excel

[Dave Shimp]

I am trying to create a hyperlink in Visio that connects to a specific
sheet in an Excel file. I've searched the other posts and found that
you can put the sheet name in the Sub-Address field. Is there a
certain syntax to follow? I am getting a "Reference is not valid"
error when attempting this.

 

[Dave Shimp]

But what is the syntax? I have multiple sheets, one of which is named
AS-02. What exactly do I put in the Sub-Address field? I tried AS-02
and received the "Reference is not valid" error.

Thanks for your help.

 

[Al Edlund]

on my system, I used the format "openbase!a2" to move to worksheet openbase
cell a2.
Your mileage may vary,
Al

 

[Dave Shimp]

Thanks for your help. I finally figured it out. I had to put the sheet
name in single quotes: 'AS-02'. I'm using Visio2000.