Linking data together?

D

Devin

Link data together so that when I change something in one document, the same
thing will change on another.
 
D

Devin

Let me clarify. It's regarding Microsoft Visio 2003. I'm working on a chart
of all the employees. Each department is also on a separate document, but
shows the same information, just easier and more specific to read. I want to
be able to link all these separate documents together to the big master chart
so that when I change something there, it will change in its corresponding
place, and vice versa. Is there a way to link the corresponding cells
together so I dont have to change each thing individually?
 
J

John Goldsmith

Hi Devin,

Well you've got a number of different options the most simple of which would
be to keep everything in a single document. You could easily set up a
"main" front page showing, for example, overview of the various departments
that could link to the more detailed departmental pages below.

If however you need to have separate documents either because a single one
would be too large or because different people need to have write access at
the same time then you need to start to consider where you main source of
data is going to be. This could obviously be in a spreadsheet or a more
formal database and if this is the case you should look at the Database
Wizard add-on (under Tools/Add-Ons/Visio Extras).

Lastly, if you are comfortable with coding such as VBA then this would open
up a number of other option where by you could synchronise the sub documents
with "master".

I haven't covered everything here, but broadly those are your basic option.
The easiest and most robust method would be the single document option but
of course it all depends on your requirements.

Let me know if your have any further questions.

Best regards

John


John Goldsmith
www.visualSignals.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top