CAD Forum discussion (EN) : CAD not opening excel links https://www.cadforum.cz/forum_en/ Tue, 09 Jun 2026 20:40:41 +0000 Thu, 15 Mar 2012 20:56:02 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://www.cadforum.cz/forum_en/RSS_post_feed.asp?TID=7496 <![CDATA[CAD Forum discussion (EN)]]> https://www.cadforum.cz/forum_en/forum_images/web_wiz_forums.png https://www.cadforum.cz/forum_en/ <![CDATA[CAD not opening excel links : xJuggleboy wrote:We cant...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19455&title=cad-not-opening-excel-links#19455 Author: SugarCAD
Subject: 7496
Posted: 15.Mar.2012 at 20:56

Originally posted by xJuggleboy xJuggleboy wrote:

We cant break the links as they are updated by others.   Thats part of the problem lol
 
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.
]]> Thu, 15 Mar 2012 20:56:02 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19455&title=cad-not-opening-excel-links#19455 <![CDATA[CAD not opening excel links : When I talk about a hyperlink...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19441&title=cad-not-opening-excel-links#19441 Author: John Connor
Subject: 7496
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


Edited by John Connor - 14.Mar.2012 at 23:12]]> Wed, 14 Mar 2012 23:10:43 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19441&title=cad-not-opening-excel-links#19441 <![CDATA[CAD not opening excel links : We cant break the links as they...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19438&title=cad-not-opening-excel-links#19438 Author: xJuggleboy
Subject: 7496
Posted: 14.Mar.2012 at 20:21

We cant break the links as they are updated by others.   Thats part of the problem lol


]]> Wed, 14 Mar 2012 20:21:16 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19438&title=cad-not-opening-excel-links#19438 <![CDATA[CAD not opening excel links : SugarCAD wrote: What version...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19437&title=cad-not-opening-excel-links#19437 Author: xJuggleboy
Subject: 7496
Posted: 14.Mar.2012 at 19:07

Originally posted by SugarCAD SugarCAD wrote:

What version of AutoCAD and what version of Excel?
 
 
You will need to sever the link and manually update. The reason you do not notice this when no one has the file open is, it updates and continues on. There should be a setting in Excel to allow multiple access with out a read only message, you might try that.
To sever the link
_OLELINKS then select the object in the list, then click the [Break Link] button.

cad 2009 and excel 2007
]]> Wed, 14 Mar 2012 19:07:57 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19437&title=cad-not-opening-excel-links#19437 <![CDATA[CAD not opening excel links : What version of AutoCAD and...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19434&title=cad-not-opening-excel-links#19434 Author: SugarCAD
Subject: 7496
Posted: 14.Mar.2012 at 18:45

What version of AutoCAD and what version of Excel?
 
 
You will need to sever the link and manually update. The reason you do not notice this when no one has the file open is, it updates and continues on. There should be a setting in Excel to allow multiple access with out a read only message, you might try that.
To sever the link
_OLELINKS then select the object in the list, then click the [Break Link] button.]]> Wed, 14 Mar 2012 18:45:40 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19434&title=cad-not-opening-excel-links#19434 <![CDATA[CAD not opening excel links : John Connor wrote:Well...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19433&title=cad-not-opening-excel-links#19433 Author: xJuggleboy
Subject: 7496
Posted: 14.Mar.2012 at 18:02

Originally posted by John Connor John Connor wrote:

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?

By "Hyperlink" I think you mean using "paste special" and "paste link". Right??  If yes. It happens to everyone here. 



Edited by xJuggleboy - 14.Mar.2012 at 18:04]]> Wed, 14 Mar 2012 18:02:40 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19433&title=cad-not-opening-excel-links#19433 <![CDATA[CAD not opening excel links : Well that&#039;s a new one on...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19401&title=cad-not-opening-excel-links#19401 Author: John Connor
Subject: 7496
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?
]]> Tue, 13 Mar 2012 22:14:25 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19401&title=cad-not-opening-excel-links#19401 <![CDATA[CAD not opening excel links : John Connor wrote:So AutoCAD,...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19398&title=cad-not-opening-excel-links#19398 Author: xJuggleboy
Subject: 7496
Posted: 13.Mar.2012 at 17:40

Originally posted by John Connor John Connor wrote:

So AutoCAD, without any input from you, will attempt to open the file that you have hyperlinked to?

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.



Edited by xJuggleboy - 13.Mar.2012 at 17:44]]> Tue, 13 Mar 2012 17:40:05 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19398&title=cad-not-opening-excel-links#19398 <![CDATA[CAD not opening excel links : So AutoCAD, without any input...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19397&title=cad-not-opening-excel-links#19397 Author: John Connor
Subject: 7496
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?
]]> Tue, 13 Mar 2012 17:30:13 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19397&title=cad-not-opening-excel-links#19397 <![CDATA[CAD not opening excel links : John Connor wrote:Wouldn&#039;t...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19396&title=cad-not-opening-excel-links#19396 Author: xJuggleboy
Subject: 7496
Posted: 13.Mar.2012 at 17:15

Originally posted by John Connor John Connor wrote:

Wouldn't you have to sever the link somehow?

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. 
]]> Tue, 13 Mar 2012 17:15:15 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=7496&PID=19396&title=cad-not-opening-excel-links#19396