Connecting inserted excel table with its source

Started by breital, January 19, 2018, 04:56:57 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

breital

Hey guys,

actually I presently have to work with Visio 2010 to create flow chart structures for my company.
The aim is to create a new connected flow chart structure where shapes are connected to each other
but also to extern data sources like e.g. excel sheets.

At the moment I'm facing the following problem:
I created a table on excel and just pasted it into Visio.
Now I'd really like to connect them with each other, so that e.g if I change any data at the Excel sheet, it also
changes at the concerning cell in Visio.

Just found a couple of vba codes. But no suitable one for this situation.
Are there any options in visio itself or with vba?
Have not that much experience in programming...  ::)

Thanks for your help! :)