Visio Guy

Solution-specific Visio Discussions => Business Process Modeling => Topic started by: turtlr on June 13, 2012, 05:03:28 AM

Title: Importing Excel Workbook Into visio
Post by: turtlr on June 13, 2012, 05:03:28 AM
Hi all,

Im taking over a a data dictionary project built in an excel spreadsheet. Its quite complex and has multiple inputs from multiple sources. Is there anyway that I can import an excel spreadsheet into Visio and populate a flow chart or an accurate visualization of the data (without using code). Im not a programmer !!

The data is financial type data with interdependancies between workbooks (im not too concerened about the interdependacies outside of the main data dictionary as its a consolidated representation of all the data). Im trying to represent this data visually in terms of flow and relationship.

Any guidance help or advice would be greatly appreciated.

Turtlr
Title: Re: Importing Excel Workbook Into visio
Post by: aledlund on June 13, 2012, 08:17:33 AM
Unfortunately that beyond the basics and would probably require some code. The one think I'd investigate is if the data can be changed into a pivot table (an excel exercise) to provide the visualization you need. If that can be done, pivot tables are importable in the professional versions.
al
Title: Re: Importing Excel Workbook Into visio
Post by: frank on January 01, 2013, 03:23:47 PM
If this is still an issue: did you try using powerpivot for excel? That should allow you visualizing the dependencies and make things more clear.