CAD Forum - Database of tips, tricks and utilities for AutoCAD, Inventor and other Autodesk products [www.cadforum.cz]
Czech English Deutsch
Login/Register:
 Visitors: 2257 
RSS tips RSS channel - CAD tips
RSS discussion RSS channel - CAD discussion

Discussion Discussion forum

HelpCAD discussion

CAD Forum - Homepage CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.

Please abide by the rules of this forum.

How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedCAD not opening excel links

 Post Reply Post Reply Page  12>
Author
xJuggleboy View Drop Down
Newbie
Newbie


Joined: 13.Sep.2011
Location: United States
Using: AutoCAD2009
Status: Offline
Points: 13
Direct Link To This Post Topic: CAD not opening excel links
    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. 
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2013, AutoCAD 2014
Status: Offline
Points: 3816
Direct Link To This Post 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 2013>>

Back to Top
xJuggleboy View Drop Down
Newbie
Newbie


Joined: 13.Sep.2011
Location: United States
Using: AutoCAD2009
Status: Offline
Points: 13
Direct Link To This Post 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. 
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2013, AutoCAD 2014
Status: Offline
Points: 3816
Direct Link To This Post 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 2013>>

Back to Top
xJuggleboy View Drop Down
Newbie
Newbie


Joined: 13.Sep.2011
Location: United States
Using: AutoCAD2009
Status: Offline
Points: 13
Direct Link To This Post 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
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2013, AutoCAD 2014
Status: Offline
Points: 3816
Direct Link To This Post 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 2013>>

Back to Top
xJuggleboy View Drop Down
Newbie
Newbie


Joined: 13.Sep.2011
Location: United States
Using: AutoCAD2009
Status: Offline
Points: 13
Direct Link To This Post 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
Back to Top
SugarCAD View Drop Down
Newbie
Newbie


Joined: 01.Mar.2012
Location: United States
Using: AutoCAD 2011
Status: Offline
Points: 13
Direct Link To This Post 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.
Back to Top
xJuggleboy View Drop Down
Newbie
Newbie


Joined: 13.Sep.2011
Location: United States
Using: AutoCAD2009
Status: Offline
Points: 13
Direct Link To This Post 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
Back to Top
xJuggleboy View Drop Down
Newbie
Newbie


Joined: 13.Sep.2011
Location: United States
Using: AutoCAD2009
Status: Offline
Points: 13
Direct Link To This Post Posted: 14.Mar.2012 at 20:21
We cant break the links as they are updated by others.   Thats part of the problem lol


Back to Top

Related CAD tips:


 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0,203 seconds.