News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Importing data from Excel into Visio

Started by DaBooch, May 17, 2011, 06:42:04 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

DaBooch

Hey all,  I am new to Visio but a quick learner.  I have figured out how to import data from an Excel File into and Org Chart but...can you select which sheet in the Excel file to import from?  My Excel file has 10 sheets (10 different Org Charts) but Visio will import from the first sheet only.  How can I specify "Sheet 6" this time and "sheet 9" next time.  I don't require data from multiple pages, just the ability to select a specific page in the Excel file.  Many thanks!

Richard.carroll

Chose "Reresh Data" from the Data tab.  Then choose "configure". Select "Change Data Source".  Choose "Excel Workbook" and select next.  Make sure the workbook name is correct and select next.  The dropdown on the following page allows you to select which worksheet that you want to use.

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 152 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1066KB.
Tokens: post-login.
Cache hits: 14: 0.00221s for 26,722 bytes (show)
Cache misses: 4: (show)
Queries used: 17.

[Show Queries]