Author Topic: Importing Excel Workbook Into visio  (Read 6241 times)

0 Members and 1 Guest are viewing this topic.

turtlr

  • Newbie
  • *
  • Posts: 1
Importing Excel Workbook Into visio
« 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

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Importing Excel Workbook Into visio
« Reply #1 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

frank

  • Jr. Member
  • **
  • Posts: 24
Re: Importing Excel Workbook Into visio
« Reply #2 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.
Best Regards
Frank