Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cairns, Queensland, Australia
    Posts
    885
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dynamically linking data (Visio 2002 SP-2 and Excel 2002 SP3)

    I have created an organizational chart in Visio from data in an Excel spreadsheet. I have one problem and one annoyance.

    The problem is with updating the org chart when changes are made in the spreadsheet. At present I create a new org chart on a new page by doing the import again every time the data changes and delete the original chart.

    The annoyance is that I have items 3 through 10 reporting to item 2. The line goes 10, 3, 4, 5
    Granville

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Dynamically linking data (Visio 2002 SP-2 and Excel 2002 SP3)

    Hi Granville,
    I am not a guru with Visio, but if I can ask...are you using the custom properties of the boxes and ODBC macros to attempt to update data between Visio and Excel?

    Also, have a look and see if you can get any extra info from this article: Automating Diagrams with Visio
    Regards,
    Rudi

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cairns, Queensland, Australia
    Posts
    885
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dynamically linking data (Visio 2002 SP-2 and Excel 2002 SP3)

    Hi Rudi

    That is a very interesting site, unfortunately not what I am after right now but should prove of interest later.

    ODBC macros? Sorry if I am being a little dense but I don't know about ODBC marcos. I think I better go and do some more reading <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

    Thanks for the input. I've now go another tact to try.
    Granville

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •