import hyperlinked standard text from Excel into Shape Data on Visio
I'm trying to display hyperlinked excel data on a Visio shape but the hyperlink doesn't transfer. Imagine I have an excel sheet for a blog. It has 3 columns, 1 for ID, 1 for Title of blog, and 1 for Author. I have the title of the blog in normal text, but the cell is hyperlinked to the actual blog. So it displays "How to Write a Blog" in the cell, and that text is hyperlinked to the actual blog content.
I import the data into Visio and display it as Shape Data, and the shape displays "How to write a blog" but the text is not hyperlinked -- how do I get that Shape Data text to be automatically hyperlinked to the blog content the same way it does when it's in the excel document?
I'm using Visio plan 2 desktop.