Why hasn't anyone answered me about worksheet tabs and org charts?

[cantaffordit]

I want to create a people list for a different company on each tab of a
spreadsheet. Viso only seems to consider the "current tab" which is the tab
that was on top when i save/close the file. Can I specify that it use Sheet1,
and the next time use Sheet2, etc? I want to keep all these companies in a
single worksheet. Please tell me if it can be done in ANY version of Visio.

 

[Al Edlund]

it would appear that the kind of flexibility to use excel the way you want
is not available using the excel interface.
al

 

[Paul Herber]

I want to create a people list for a different company on each tab of a
spreadsheet. Viso only seems ...

Hi, do you really mean Visio? Excel is the Office spreadsheet program.

If you are using Visio it will save the current active page if you
have saved the workspace. otherwise it will always open page 1.

 

[John Marshall, MVP]

The way the Visio Orgchart wizard is setup, it expects the information in
the first worksheet. There is no way for it to use any of the other
worksheets in an Excel workbook.

John... Visio MVP

Need stencils or ideas? http://visio.mvps.org/3rdparty.htm
Need VBA examples? http://visio.mvps.org/VBA.htm
Visio Wishlist http://visio.mvps.org/wish_list.htm