Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Linking Visio Drawing into Excel-Sheet

Posted on 2014-11-17
8
Medium Priority
?
2,177 Views
Last Modified: 2014-12-22
Hi there

I'm looking for a solution on pasting a Visio-Drawing into an Excel-Sheet.
Only copy and paste is one thing.
But I'd like to be able to paste/link the drawing into excel and after editing the drawing in Visio the changes will also take place in Excel.
In Word there is this Option with linked Objects and "Update Link" but I can't find this Option in Excel?

Any help is appreciated
Rgds Marcel
0
Comment
Question by:mz72
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
8 Comments
 
LVL 16

Accepted Solution

by:
Rajitha Chimmani earned 2000 total points
ID: 40448221
You have the same option in link as in Excel. Goto Insert tab->Click on Object and Select Create from File tab. Browse for the file and select "Link to File" checkbox. I see it on Excel 2010 and 2013. Which version of Excel?
0
 

Author Comment

by:mz72
ID: 40449242
Thanks very much for your help.
I think I just forgot to set the Option "Link to file".
Now it works perfect.

But there is now another question I hope you can help me with.

From this Excel-Sheet (Excel 2010) I'd like to link the Visio Option including the table next to it into a Word-Document (Word 2010).
This works partially. The thing is that it is not taking the whole Object/Content of the Worksheet, only part of it. It cuts around 70% from the bottom off.
I tried with the existing Document I've got and also with a blank Word-Document.

The case is to create 1 Excel-Workbook with several Worksheets in.
On every Worksheet I've got the Visio-Object of one of our Server-Racks (linked from the Visio-Drawing) and next to it a Table with all the installed Hardware, Host-Names etc.
This Worksheet needs to be linked into a Word-Document for the complete Server-Documentation.

I hope this explanation is understandable to you?

Thanks in advance for your help.
Rgds Marcel
0
 

Author Comment

by:mz72
ID: 40449436
I don't know why, but the Part of the Problem where the Object is cut off suddenly disappeard.

The other Problem where I need to define which Worksheet needs to be selected is still there.
When I switch Worksheet from the Workbook I linked in Word it also switches to this Worksheet in my Word-Document.

Is there a possibilty to fix to which Worksheet the Link is going to?

I tried several possibilties like Path to File=Sheet1!A1:B12 or "Path to File=Sheet1!A1:B12" and so on...

Thanks in advance
Rgds Marcel
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 16

Expert Comment

by:Rajitha Chimmani
ID: 40450407
Unfortunately, there does not seem to be a way to insert it as icon. Only the actually content on the worksheet can be inserted.
0
 

Author Comment

by:mz72
ID: 40456811
Thanks for the post and sorry for my late answer.

Ok, then I need to try it another way.

BUT unfortunately there is my problem with cutting off part of the Excel-Sheet into Word again! Or even worst case the Object is not displayed at all!
I tried several ways to fix this.
Different Excel, Word and Visio Versions. (Visio 2003, 2007, 2013, Word 2010, Excel 2010). Unfortunately I've got no Visio 2010 Version.
Any ideas what the reason of this missbehaviour could be?
Check attachements

Thanks and regards
Marcel
Visio-Object-linked-in-Excel.JPG
Excel-Object-linked-in-Word.JPG
0
 
LVL 16

Expert Comment

by:Rajitha Chimmani
ID: 40457657
Unfortunately, its a limitation due to the size. Possible that you are trying to insert at the end of the current page and hence does not display it completely. Try to move the pointer to next page and insert it.

http://office.microsoft.com/en-us/word-help/troubleshoot-linked-objects-and-embedded-objects-HP005189818.aspx
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 40512656
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question