Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.
Linking Fields Between Pages In Visio
Is it possible in Visio to link blocks of data in Visio so that if I fill a field of information in one page it is automatically filled in another page located on a different tab in the workbook? This would be similar to what you can do in excel. Right now I am typing in the information on my main page and then duplicating the exact same information on two other pages. This is not very efficient.
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Maybe using the word "Link" wasn't the correct way to describe my issue. I don't want to create a hyperlink. I want to type a word in a block on one page and have it automatically duplicated into other blocks on other pages. Like in Excel where you can type something in one page and program it to then fill other other pages automatically because those pages have fields that are linked to the field on the first page where you typed the information.
The comment from Rajul above is about creating a hyperlink from one page to another -- very useful but not what you want to do.
I can think of three techniques for duplicating data values on multiple pages.
1) Enter data into shapes on one page (as you've done), and then create shapes that contain ShapeSheet formula that refer to the fields in the "master" shapes.
2) Store the data in ShapeSheet fields in the document and then create shapes that contain ShapeSheet formula that refer to the document's data fields.
3) Store the data in an external data source, e.g., Excel, link the diagram to the data source, and then link each row of data to specific shapes (each data row can be linked to multiple shapes).
All three options will allow you to change data values in one place and have the new values appear in multiple places.
Options 1 and 2, while viable, require knowledge of the Visio ShapeSheet and will require some 'behind the scenes' tinkering with multiple ShapeSheets. I definitely don't want to dissuade anyone from learning about the ShapeSheet (in fact, if you're interested, take a look at Part 1 of this free, three-part course I created at Microsoft Virtual Academy).
Nevertheless, I would recommend option 3. Not only is it often easier to maintain your source data in Excel (or a database or a SharePoint list) but you can accomplish what you're asking about just using the Visio user interface; you won't need to mess with the ShapeSheet.
To learn about data linking, a couple of suggestions:
-- Take a look at video #8 in The MVP Sessions. Though created for Visio 2010, the essential details are still relevant, despite a few UI changes in Visio 2016.
-- Try this page of Office help.
-- Read chapter 10 in Visio 2016 Step by Step; details about the book are on my EE profile page.
[/list]
I can think of three techniques for duplicating data values on multiple pages.
1) Enter data into shapes on one page (as you've done), and then create shapes that contain ShapeSheet formula that refer to the fields in the "master" shapes.
2) Store the data in ShapeSheet fields in the document and then create shapes that contain ShapeSheet formula that refer to the document's data fields.
3) Store the data in an external data source, e.g., Excel, link the diagram to the data source, and then link each row of data to specific shapes (each data row can be linked to multiple shapes).
All three options will allow you to change data values in one place and have the new values appear in multiple places.
Options 1 and 2, while viable, require knowledge of the Visio ShapeSheet and will require some 'behind the scenes' tinkering with multiple ShapeSheets. I definitely don't want to dissuade anyone from learning about the ShapeSheet (in fact, if you're interested, take a look at Part 1 of this free, three-part course I created at Microsoft Virtual Academy).
Nevertheless, I would recommend option 3. Not only is it often easier to maintain your source data in Excel (or a database or a SharePoint list) but you can accomplish what you're asking about just using the Visio user interface; you won't need to mess with the ShapeSheet.
To learn about data linking, a couple of suggestions:
-- Take a look at video #8 in The MVP Sessions. Though created for Visio 2010, the essential details are still relevant, despite a few UI changes in Visio 2016.
-- Try this page of Office help.
-- Read chapter 10 in Visio 2016 Step by Step; details about the book are on my EE profile page.
[/list]
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
Hey, Dave -- did you have a chance to experiment with creating the data links you need? No problem if not, but the automated software at EE is trying to close this question so i thought I'd post this comment to keep it open a bit longer.
Have not had a chance yet. I'll copy what is here so I can try at a later date and not lose the suggestions.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Visio
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
http://tutorial.programming4.us/windows_7/Microsoft-Visio-2010---Linking-to-Another-Visio-Page.aspx