Excel Spreadsheet linking to Visio Flowchart

[Jazz]

Has anyone heard of or familiar with taking an existing spreadsheet and using
it to create a flowchart in visio - it seems to have been created using some
type of automatic function. Like the former user clicked a "make now" or
"create now" button, and all the contacts were then loaded into a nice neat
flow chart.

The thing is, the creator of this chart is no longer with the company and
now it is time to update the flow chart. The person responsible is making
the changes in Excel, however they are not showing (not updating
automatically) in Visio . There does not appear to be any "update links"
message in either application after save and re-open. With some picking
through the software, I was not able to find any macros, buttons or menus
that appeared to perform this action.

Any one ever hear of such a thing - I have been using Office and Visio for
years, but I have never heard of such a thing -- but it appears to have been
done....

Help, please!

 

[Bob Buckland ?:-\)]

Hi Jazz,

You may want to post this in the MS Office Visio newsgroup
(link below) and include the versions of Excel and Office
you're using.

It's not clear if you're doing an Orgchart or Flowchart
but it sounds like the Excel database were linked to the
Visio shapes in fields.

If an Orgchart the OrgChart wizard would be one method
to create a chart to see the process.
Create a New diagram and locate the Wizard in the OrgChart example stencils.

=========
Has anyone heard of or familiar with taking an existing spreadsheet and using
it to create a flowchart in visio - it seems to have been created using some
type of automatic function. Like the former user clicked a "make now" or
"create now" button, and all the contacts were then loaded into a nice neat
flow chart.

The thing is, the creator of this chart is no longer with the company and
now it is time to update the flow chart. The person responsible is making
the changes in Excel, however they are not showing (not updating
automatically) in Visio . There does not appear to be any "update links"
message in either application after save and re-open. With some picking
through the software, I was not able to find any macros, buttons or menus
that appeared to perform this action.

Any one ever hear of such a thing - I have been using Office and Visio for
years, but I have never heard of such a thing -- but it appears to have been
done....

Help, please!
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.visio
or via browser:
http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.visio
B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Jazz]

Thank you, I will try the Visio new group! Thanks for your assistance.