Ms Visio/excel

[PoolMan]

Can you import to visio with excel ??? Just wondering if this was possible.


Thanks
PoolMan

[oldchippy]

I've just tried importing a visio file from my memory stick into Excel without success.

[PoolMan]

ok thanks a bunch .

PoolMan

[oldchippy]

Did you want to import Visio into Excel or Excel into Visio? Only i have the Visio programme on my work PC not on my home PC, so I will try tomorrow.

[PoolMan]

yes excel to visio let me know if you have any luck


poolman

[oldchippy]

The answer is YES you can. If you copy your spreadsheet, then go into Visio, go to Edit > Paste Special, there's an option to paste an Excel spreadsheet.

Also going the other way, you can copy a drawing and just Edit > Paste into Excel, but it trends to put a border around it, so just right-click, format object and remove the border

Hope this helps?

[anonali]

okay, copy/paste I can do, but foes anyone know if it is possible to have data in a visio file auto update from individual cells in an excel spreadsheet?
onThe nearest I've come id to copy the visio diagram into excel, ungroup it, and make it transaprent such that I can have rge excel data lie behind the image, but visible. Quite frankly, this is an almighty pain, and wholly impractical so any suggestions would be welcome.

Many thanks,

Anon

[oldchippy]

Here's another way. You have your data in cells on a spreadsheet, you also have your Visio drawing on your spreadsheet (but to the left or right of the drawing so that you can see it), go to the Drawing toolbar, click on the Text box, draw one on the Visio drawing.

With the Text box active, put your cursor in the Formula bar (next to fx), then press the equals sign and click the cell on the spreadsheet with your data in. You should now have the data over your drawing.

Now when you update your data the drawing is updated.

[Bryan Hessey]

okay, copy/paste I can do, but foes anyone know if it is possible to have data in a visio file auto update from individual cells in an excel spreadsheet?
onThe nearest I've come id to copy the visio diagram into excel, ungroup it, and make it transaprent such that I can have rge excel data lie behind the image, but visible. Quite frankly, this is an almighty pain, and wholly impractical so any suggestions would be welcome.

Many thanks,

Anon

Hi,

it is possible to have a Visio drawing update from Excel, asin a Visio picture getting Names from Excel for a seating plan etc, the data is updated when Visio opens, but is painfully slow.

It is usually done to preserve the status of the drawing from the 'uneducated' name updater, however, it is better to utilise Visio's Layer capabilities to protect various aspects of the drawing and leave open to edit just the one 'layer' of information (the names) required for update.

As I recall, to set the link, when you define a Textbox (in Visio) you link it to the cell of the required worksheet, but I have no room to run Visio on this system.

hth
---