Making unused data-linked SharePoint columns in Visio invisible automatically

I described how and why I sometimes link a SharePoint document library to Visio documents in a previous article ( see I mentioned that I always switch off the visibility of some columns because they are rarely needed in my Visio shapes as shape data rows. In this article, I present a VBA macro that can switch them off for you, therefore ensuring consistency.

The Link Data to Shapes feature in Visio does not allow for filtering of columns or rows when SharePoint lists are used as a data source. One answer is to create a view of the list in SharePoint to restrict the rows and some columns, but other columns still get pulled through to the External Data recordsets in Visio by default:


Read the rest of this entry »

A Table of Visio Data Graphic Icon Sets

I have previously written blog articles about using, and extending, the Microsoft supplied Data Graphic Icons Sets, but I never explicitly listed their variations in a useful visual table. So, here is one:

Read the rest of this entry »

The history of Visio

I have been a dedicated user and developer of Visio since 1996 when I got a week-long developer training course presented by Dave Edson (see ) and Mark Davison in Paris. Previous to that, I had been working with CAD and databases (or spread sheets), but I had noticed either version 1 or 2 of Visio on a computer mag cover disk, and earmarked it for future investigation.

We have recently been made aware that Ted Johnson, one of the original founders, has a website with the history of Visio up to the acquisition by Microsoft in 1999 ( see ). It is fascinating reading, and there are lots of faces that I met there, plus some that you should still be aware of ( eg Chris Roth, aka VisGuy ).

image image
image image
1992 2015

Visio is a unique product, and the story of Visio shows that it is a well-loved one, with an enthusiastic team behind it, and an watchful community eager to see it further develop!

Posted in Visio. Tags: . Leave a Comment »

Updating the file path of data linked Excel tables in Visio

Link Data to Shapes in Visio (not the Standard edition though) is great for visualizing information, and I often use a multi-worksheet Excel workbook that I create locally, and then wish to re-link to a copy of the workbook elsewhere, or even in Office365. This is a simple task if there are only one or two Excel tables involved, but can become tedious when there are many. So, this blog is presents an semi-automated method of achieving this.

Read the rest of this entry »


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