Importing data from Excel into Visio

[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.