CAD not opening excel links
Printed From: CAD Forum
Category: EN
Forum Name: CAD - general
Forum Description: General discussion about CAD, formats, standards, management, licensing, networking, harware, other CAD applications
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496
Printed Date: 09.Jun.2026 at 11:27
Topic: CAD not opening excel links
Posted By: xJuggleboy
Subject: CAD not opening excel links
Date Posted: 13.Mar.2012 at 16:21
|
If I open a DWG file and it has a excel link in it, and someone else has the Excel file open, CAD will open the Excel file also and lock up my computer until the dialog box in excel is clicked. Is there any way to stop CAD from opening excel?? It dosent do this if nobody is in the Excel file. |
Replies:
Posted By: John Connor
Date Posted: 13.Mar.2012 at 17:06
|
Wouldn't you have to sever the link somehow?
------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |
Posted By: xJuggleboy
Date Posted: 13.Mar.2012 at 17:15
Im not sure why that would need to be done. Excel dosent open when someone is not in it. Why does it try to open Excel when someone is in it? That seems to be an awful feature.
|
John Connor wrote:Posted By: John Connor
Date Posted: 13.Mar.2012 at 17:30
|
So AutoCAD, without any input from you, will attempt to open the file that you have hyperlinked to? ------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |
Posted By: xJuggleboy
Date Posted: 13.Mar.2012 at 17:40
Yes. When I open the DWG in CAD, it will try and open any Excel file that has been linked that someone is using. *EDIT* The problem is if someone is using the file you get a dialog that asks you to open it read only, notify, or cancel. Many times that dialog box takes a long time to show up. |
Posted By: John Connor
Date Posted: 13.Mar.2012 at 22:14
|
Well that's a new one on me. Never had any problem like it although I use hyperlinks very sparingly. Does this happen in all drawings that have a hyperlink to an Excel spreadsheet? ------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |
Posted By: xJuggleboy
Date Posted: 14.Mar.2012 at 18:02
By "Hyperlink" I think you mean using "paste special" and "paste link". Right?? If yes. It happens to everyone here. |
Posted By: SugarCAD
Date Posted: 14.Mar.2012 at 18:45
|
What version of AutoCAD and what version of Excel? To sever the link _OLELINKS then select the object in the list, then click the [Break Link] button.
|
Posted By: xJuggleboy
Date Posted: 14.Mar.2012 at 19:07
cad 2009 and excel 2007
|
Posted By: xJuggleboy
Date Posted: 14.Mar.2012 at 20:21
|
We cant break the links as they are updated by others. Thats part of the problem lol |
Posted By: John Connor
Date Posted: 14.Mar.2012 at 23:10
|
When I talk about a hyperlink I mean just that. I am not talking about "paste special" and "paste link". AutoCAD Hyperlink command: http://blog.jtbworld.com/2007/09/autocad-hyperlink-command-basics.html ------------- "Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>> |
Posted By: SugarCAD
Date Posted: 15.Mar.2012 at 20:56
You have set up an automatic link to Excel from AutoCAD in a drawing, everytime you open that drawing, AutoCAD connects and updates, if someone has the drawing open AutoCAD cannot update, but must wait until the Excel file is not Read Only and other user is logged out. No problems, AutoCAD just did everything you have asked it to do. Either live with it or break the link and update manually, or look into setting up a "Shared Workbook" in Excel. In Excel 2007 look under "Review" for "Shared Workbook" and help or office assistant to set up.
|