News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Editing shape text from Excel

Started by jmak94, February 27, 2012, 08:01:56 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jmak94

Hello all, just joined.
I've searched for a couple hours here on the forum and across the net and haven't found what I have been looking for, save for some VB code.

I have Visio Premium 2010 and Excel 2010. I am trying to link an Excel sheet to my Visio drawing. I have made it so far as to bring in the Excel sheet as an external reference inside Visio and link my Excel data to my Visio shape data.

Now the problem,
No matter what I do I can't get the 'shape text' to update. For example I have an indicator shape with text '1000'. In Excel, and the Visio shape data, I have changed this indicator to '1001'. The shape however still reads as '1000'. Is there a way to get this value to sync through Visio/Excel without having to use VB code? I would really not like to use VB code for this as other people might edit this file in the future.

A second problem I am seeing is that if I edit the shape data in Visio, it will not update automatically in Excel. I assume this is because I have to go through and do a shape report, but this seems tedious. Is there a simpler way to do this?

Thank you all! This seems to be an excellent forum which I will be using a lot as I am brand new to Visio.

jmak94

I found out a way using custom tags. Still would like other peoples input though.

Bubba2413

looking for something similar, but from word vs excel.. how did you get yours done?

jmak94

I'm using 2010, so things may be different.

I went to the Data tab, then to Link Data to Shapes. This brings up a box for selecting where your data is from. These are the options:
Excel, Access, MS SharePoint, MS SQL, or Other OLEDB or ODBC.

So I'm not sure if you can actually use Word unless you write your own VB code. Can you bring it into Excel?

After this, in Excel, You can set up your columns of data and use this information to link to your shapes. You may have to edit your shapes Tag so that "Example Column Name" from Excel can link to "Example Column Name" in your Visio tag.

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 187 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1054KB.
Tokens: post-login.
Cache hits: 13: 0.00394s for 26,731 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]