Visio Wizard

S

segargal1

working with Microsoft Visio 2002. I made up an excel spreadsheet with
multiple sheets to transfer into an org chart. When using the wizard I only
get one sheet of the whole workbook. How can I transfer the entire workbook
that consists of 5 pages? Need to know quickly please
--
 
J

John... Visio MVP

segargal1 said:
working with Microsoft Visio 2002. I made up an excel spreadsheet with
multiple sheets to transfer into an org chart. When using the wizard I
only
get one sheet of the whole workbook. How can I transfer the entire
workbook
that consists of 5 pages? Need to know quickly please
Click to expand...

When Visio creates an Orgchart from an Excel spreadsheet, it uses the last
worksheet opened to determine which worksheet to use.

So to handle your five pages you will need to open the Excel workbook,
select the sheet and close Excel for each of the five worksheets.

My preferred way would be to combine the five worksheets into one and use
the wizard to page break by the people you select to be at the top of the
page.

John... Visio MVP
 
Top