I have recently been working on an FM project where I have spaces and personnel shapes in Visio floor plans data linked to Excel tables. I constructed a number of related tables in an Excel workbook and wanted to demonstrate the relationships. I decided that this is best explained with a combination of a diagram and sample data , so this article describes how to connect Visio and Excel web parts together in SharePoint 2013 web pages, without code.

Preparation

First, I constructed an Excel Services workbook and a Visio Services document.

Excel Workbook Tables

The Excel workbook has a number of tables on similarly named worksheets.

[Read more…] about Connecting Visio and Excel Web Access controls in SharePoint 2013