Hyperlinks from Visio to Excel for non Visio users | Visio forum

Resolved · Urgent Priority · Version 2013

Wed 5 Apr 2017, 15:22 Delegate Pamela said...

Pamela has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course
Emotional Intelligence at Work course

Hyperlinks from Visio to Excel for non Visio users

Hi there

I have a Visio document with multiple tabs, a corresponding Excel document with multiple tabs, and a Word document with multiple bookmarks. I want to link a specific tab within Visio to a specific tab within Excel and to a specific bookmark in Word. I have used hyperlinks in order to do so, which works absolutely perfectly for any Visio users.

The problem is that the users of these documents will not have Visio installed on their PC's.

So the user will view the Visio document as a webpage.
The hyperlink from the webpage version of the Visio map to a specific tab in excel and specific bookmark in Word is lost, and instead the non-Visio user is directed to the last tab that the Excel document was saved on and last place saved on the Word document. I need the hyperlinks to remain on the webpage version of the Visio maps, and link to the specific tabs in Excel and specific bookmark in Word.

Are you able to provide a solution for this?
I have tried and tested many many methods, and cannot find a solution.

Hoping you will be able to shed some light on this.

Best wishes

Pamela

Fri 7 Apr 2017, 10:46 Trainer Andrew said...

RE: Hyperlinks from Visio to Excel for non Visio users

Hi Pamela

Thank you for your question - I've checked with my colleagues and unfortunately this is outside the scope that we can cover on the forum. It sounds like there's a degree of VBA and development required to create a working solution. We can work with you to develop this on a consultancy basis - and if that is of interest please let me know.

I'm sorry we couldn't be of more immediate help this time.

Kind regards,
Andrew

Fri 14 Apr 2017: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Visio tip:

Creating an organisation chart in Visio using Excel data

A quick and easy way to create an organisation chart by importing names and titles stored in list format in an Excel spreadsheet into Visio.

1. Select File, New, Organization Chart.

2. Start the Organization Chart Wizard.

3. At the first step of the wizard, select the 'Information that I enter using the wizard' option, and click Next.

4. At the second step of the wizard, select Excel, then type the name of the file.

5. Select Browse to choose the location you wish to save the file to, click Save, and then click Next.

6. Click OK - a Microsoft Office Excel workbook will open with column headings already entered for you.

7. Replace the sample text with the text you wish to appear in your organisation chart. By holding your cursor over each column heading, you should be able to view data entry tips.

8. Save the Excel file, then close Excel.

9. Proceed through the remaining steps in the wizard to create your organization chart from the data you entered into the Excel file.

Visio's organisation chart wizard will also recognise the following file formats (besides .xls):

- Microsoft Exchange Server Directory (Microsoft Exchange e-mail Address Book).

- Tab- or Comma-delimited text (.txt).

- Org Plus (.txt).

- Microsoft Office Access (.mdb) or any other file format for a database created in an Open Database Connectivity (ODBC)-compliant database application.