Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data Graphics

Data Graphics

Data Graphics

This is a two part question?

I have created a spreadsheet that I have been able to successfully merge into a Visio 2007 document. I have successfully link data graphics to various stencils. I am having a coupe of problems.
If I understand the reasoning behind data graphics and linking to an external source (i.e. excel spreadsheet) is that you can change the data in the spreadsheet and not have to update the Visio document other than to do a refresh and the data should updates. This is very useful if you have a standardized build which our company does makes pushing out configurations and Visio diagrams very efficient.

My problems are as follows.
1.    When I update my spreadsheet and then return to Visio2007 and proceed with a refresh of the data my link gets deleted. This leads to/or is the cause of my second issue.
2.    Once my link get broken from issue 1. I have to re-link the data back to the object this then sets the data graphic back to its default which then I have to hand edit the bubbles/callouts and move them back to the desired position.
This exercise kind of defeats the purpose of linking to the spreadsheet. Has anyone else seen this behavior? Am I missing a step when defining my data graphics or linking to my spreadsheet.

Any suggestions are welcomed.



RE: Data Graphics

I am not sure why your links are breaking, but if you assign a unique key, like a product id to a shape data and then use that product id in the spreadsheet, you should be able to automatically link the data based on the key. |This is under the data menu.
I have been able to do this a few times this morning and the refresh works without losing the links.

John...   Visio MVP - Visio.MVPs.org

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close