Visio Shape Data Linking Tips

I often use the Microsoft supplied OrgData.xls sample file to demonstrate linking to external data in Visio, however there are a few gotchas lying in wait for the unwary if you try to link to the Microsoft supplied Org Chart shapes …

In the following screenshot, I have the OrgData table showing in the External Data window and I have the ShapeSheet open for the selected Executive Belt shape. Notice that the Shape Data section rows are all black which indicates that they are inherited from the master shape. Also note that there is a Shape Data row with the label “E-Mail” in the ShapeSheet, and one called “E-mail” in the Personnel table.



Read the rest of this entry »

Microsoft Visio Webinar Series

Microsoft Western Europe are running a series of webinars about Visio over the next few months. Apparently, I am presenting two of them Smile

The first one is on 12th November 2015 about Tips and techniques to automate Visio infrastructure diagramming, so check out the following url soon :


O365 and SharePoint

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query

Azure Solutions for Office 365, and more...

Rob Fahrni



Life with Visio and other Microsoft Toys!

Nilsandrey's Weblog

Just another weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Smart graphics for visual people