Hello all,

Is there a way to export information regarding relationships from a visio
diagram to an excel spreadsheet?

In addition, is there a way to tell the excel spreadsheet to eliminate or
change a relationship and for that action to be applied onto the visio
diagram?

thanks,
ivan

as a general answer I'd have to say "no, not without custom code". You
didn't define what you meant as a relationship.
al

"Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message
news:6332A594-E4AF-4E8B-BA2D-7A4BC17962B3@microsoft.com...
> Hello all,
>
> Is there a way to export information regarding relationships from a visio
> diagram to an excel spreadsheet?
>
> In addition, is there a way to tell the excel spreadsheet to eliminate or
> change a relationship and for that action to be applied onto the visio
> diagram?
>
> thanks,
> ivan

By relationship, I simply mean a link between one object and the other (a
arrow or a line).

What I really want to be able to do is to create a "master diagram" that
contains all the relevant information that I need and then be able to create
other diagrams that are only portions of that master diagram.

When a change is made to the master, I want it to be automatically reflected
in all the other related diagrams. Is that possible?

"Ivan Salas" wrote:

> Hello all,
>
> Is there a way to export information regarding relationships from a visio
> diagram to an excel spreadsheet?
>
> In addition, is there a way to tell the excel spreadsheet to eliminate or
> change a relationship and for that action to be applied onto the visio
> diagram?
>
> thanks,
> ivan

By relationship, I simply mean a link between one object and the other (a
arrow or a line).

What I really want to be able to do is to create a "master diagram" that
contains all the relevant information that I need and then be able to create
other diagrams that are only portions of that master diagram.

When a change is made to the master, I want it to be automatically reflected
in all the other related diagrams. Is that possible?

"Ivan Salas" wrote:

> Hello all,
>
> Is there a way to export information regarding relationships from a visio
> diagram to an excel spreadsheet?
>
> In addition, is there a way to tell the excel spreadsheet to eliminate or
> change a relationship and for that action to be applied onto the visio
> diagram?
>
> thanks,
> ivan

apologies, now the answer get's a little muddied.
export relationships=>you can use the database wizard to save and change
information
automatically be reflected in related diagrams=>custom code (assumption
here is that you might delete/add objects)
al

"Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message
news:6D06D79F-72F3-4145-851F-23882AE46CBD@microsoft.com...
> By relationship, I simply mean a link between one object and the other (a
> arrow or a line).
>
> What I really want to be able to do is to create a "master diagram" that
> contains all the relevant information that I need and then be able to
> create
> other diagrams that are only portions of that master diagram.
>
> When a change is made to the master, I want it to be automatically
> reflected
> in all the other related diagrams. Is that possible?
>
> "Ivan Salas" wrote:
>
>> Hello all,
>>
>> Is there a way to export information regarding relationships from a visio
>> diagram to an excel spreadsheet?
>>
>> In addition, is there a way to tell the excel spreadsheet to eliminate or
>> change a relationship and for that action to be applied onto the visio
>> diagram?
>>
>> thanks,
>> ivan

apologies, now the answer get's a little muddied.
export relationships=>you can use the database wizard to save and change
information
automatically be reflected in related diagrams=>custom code (assumption
here is that you might delete/add objects)
al

"Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message
news:6D06D79F-72F3-4145-851F-23882AE46CBD@microsoft.com...
> By relationship, I simply mean a link between one object and the other (a
> arrow or a line).
>
> What I really want to be able to do is to create a "master diagram" that
> contains all the relevant information that I need and then be able to
> create
> other diagrams that are only portions of that master diagram.
>
> When a change is made to the master, I want it to be automatically
> reflected
> in all the other related diagrams. Is that possible?
>
> "Ivan Salas" wrote:
>
>> Hello all,
>>
>> Is there a way to export information regarding relationships from a visio
>> diagram to an excel spreadsheet?
>>
>> In addition, is there a way to tell the excel spreadsheet to eliminate or
>> change a relationship and for that action to be applied onto the visio
>> diagram?
>>
>> thanks,
>> ivan

When I'm using the wizard to import info from an Excel spreadsheet into
Visio, it brings in all of my information correctly; puts subordinates under
the proper executive, etc., however it will not import them in the order that
I type them into the spreadsheet. For example, I have one executive with six
subordinates and it puts the correct subordinates under the correct
executive, but mixes up the order...how do I stop that from happening?

"Ivan Salas" wrote:

> Hello all,
>
> Is there a way to export information regarding relationships from a visio
> diagram to an excel spreadsheet?
>
> In addition, is there a way to tell the excel spreadsheet to eliminate or
> change a relationship and for that action to be applied onto the visio
> diagram?
>
> thanks,
> ivan

When I'm using the wizard to import info from an Excel spreadsheet into
Visio, it brings in all of my information correctly; puts subordinates under
the proper executive, etc., however it will not import them in the order that
I type them into the spreadsheet. For example, I have one executive with six
subordinates and it puts the correct subordinates under the correct
executive, but mixes up the order...how do I stop that from happening?

"Ivan Salas" wrote:

> Hello all,
>
> Is there a way to export information regarding relationships from a visio
> diagram to an excel spreadsheet?
>
> In addition, is there a way to tell the excel spreadsheet to eliminate or
> change a relationship and for that action to be applied onto the visio
> diagram?
>
> thanks,
> ivan

by design the tool randomizes the dropping of the objects to improve
performance. you might consider linking the objects (managers/subordinates)
after the drawings has been created using v2007 datalinking.
al

"ldupre" <ldupre@discussions.microsoft.com> wrote in message
news:08040911-FEE2-4426-91CF-1CB1C1C432B2@microsoft.com...
> When I'm using the wizard to import info from an Excel spreadsheet into
> Visio, it brings in all of my information correctly; puts subordinates
> under
> the proper executive, etc., however it will not import them in the order
> that
> I type them into the spreadsheet. For example, I have one executive with
> six
> subordinates and it puts the correct subordinates under the correct
> executive, but mixes up the order...how do I stop that from happening?
>
> "Ivan Salas" wrote:
>
>> Hello all,
>>
>> Is there a way to export information regarding relationships from a visio
>> diagram to an excel spreadsheet?
>>
>> In addition, is there a way to tell the excel spreadsheet to eliminate or
>> change a relationship and for that action to be applied onto the visio
>> diagram?
>>
>> thanks,
>> ivan

by design the tool randomizes the dropping of the objects to improve
performance. you might consider linking the objects (managers/subordinates)
after the drawings has been created using v2007 datalinking.
al

"ldupre" <ldupre@discussions.microsoft.com> wrote in message
news:08040911-FEE2-4426-91CF-1CB1C1C432B2@microsoft.com...
> When I'm using the wizard to import info from an Excel spreadsheet into
> Visio, it brings in all of my information correctly; puts subordinates
> under
> the proper executive, etc., however it will not import them in the order
> that
> I type them into the spreadsheet. For example, I have one executive with
> six
> subordinates and it puts the correct subordinates under the correct
> executive, but mixes up the order...how do I stop that from happening?
>
> "Ivan Salas" wrote:
>
>> Hello all,
>>
>> Is there a way to export information regarding relationships from a visio
>> diagram to an excel spreadsheet?
>>
>> In addition, is there a way to tell the excel spreadsheet to eliminate or
>> change a relationship and for that action to be applied onto the visio
>> diagram?
>>
>> thanks,
>> ivan