pasteing an excel cell into visio drawing

[slydel]

Is there an easy way to link individual cells from and excell worksheet to a
drawing in Visio so the data in Excel will be seen in Visio and be updated
each time Excel is updated? I'm using the copy and paste special as a
"Microsoft Excel Worksheet" but the data shown is not easily formatted. I
need the information to be inside a retangle shape which can be adjusted
without the font changing.

Thanks

 

[JuneTheSecond]

I dont know what is easy way. But Visio has ways to link with
excel data ao some other database. Please check the menu
tool/addons/Visio extra..., or user can make program that
helps to link with the data. For formatting text in shapes,
a study how to use shapesheet migh be a help.

 

[Mark Nelson [MS]]

If you are willing to download Visio 2007 Beta 2, you can use the new Data
Link and Data Graphics features to easily do this.

Download: http://www.microsoft.com/office/preview/default.mspx

Info on features:
http://blogs.msdn.com/eric_rockey/archive/2005/12/06/500395.aspx


--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.