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.
This is a peer-to-peer forum. The forum doesn't replace the official direct technical support provided by ARKANCE for its customers.
How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
| Author |
 Topic Search  Topic Options
|
tulip3D 
Senior Member
Joined: 23.Jul.2009
Location: United States
Using: AutoCAD2011, Inventor2011
Status: Offline
Points: 427
|
 Topic: Data Link problems with Excel in 2010
Posted: 11.Mar.2015 at 18:59 |
Consider this thead DEAD. As always, your help and expertise is much appreciated John C.
|
 |
tulip3D
Senior Member
Joined: 23.Jul.2009
Location: United States
Using: AutoCAD2011, Inventor2011
Status: Offline
Points: 427
|
Posted: 11.Mar.2015 at 18:58 |
Well your right on that point, it does retain the same physical size... I'm essentially trying to replace a whole ERP system with a common excel file and autoCAD...guess I'm shooting the moon LOL Love working here, but their systems and design process is stoneage, at best. I saw one of those programs (I think the 'parts dept' was using) that you have to use arrow keys and letters to navigate....about to party like its 1999 LOL
|
|
John Connor
Senior Member
Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
|
Posted: 11.Mar.2015 at 18:26 |
|
I just delete the previous one and reinsert. I don't use the method all that often. I just suggested it because I thought there would be a better chance of retaining the original format from Excel.
Edited by John Connor - 11.Mar.2015 at 18:27
|
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>>
|
|
tulip3D
Senior Member
Joined: 23.Jul.2009
Location: United States
Using: AutoCAD2011, Inventor2011
Status: Offline
Points: 427
|
Posted: 11.Mar.2015 at 18:13 |
It works but theres no link? I simply selected cells in excel, 'paste special' and insert an OLE object...I can double click and it opens the excel file...but when i changed in excel it did not 're'import back to CAD file? Do I need to invoke something?
|
|
John Connor
Senior Member
Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
|
Posted: 11.Mar.2015 at 17:05 |
|
Maybe you should try using PasteSpec instead (as a test). Perhaps you'll have better results.
|
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>>
|
|
tulip3D
Senior Member
Joined: 23.Jul.2009
Location: United States
Using: AutoCAD2011, Inventor2011
Status: Offline
Points: 427
|
Posted: 11.Mar.2015 at 16:27 |
I did: 'heck no' was the response. Man you love to state the obvious LOL... Problem is, now the columns are changing width. I figured out that last issue was attributed to settings in the data link dialog box, matching formatting to either acad or excel...excel uses 'font size' aka 8 or 10 or 12. acad dosnt have that, so it defaults to something close. I think my 'column width' issue is something related to the same 'conversion' issues as the font...
|
|
John Connor
Senior Member
Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
|
Posted: 11.Mar.2015 at 16:06 |
|
You did not answer my question re: PasteSpec.
Thank you for just one more good example of what not to do in a CAD drawing.
I've used datalinks maybe a couple dozen times and have never had a spreadsheet reformat itself as you show in your original post. The results you get are simply astounding.
|
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance." <<AutoCAD 2015>>
|
|
tulip3D
Senior Member
Joined: 23.Jul.2009
Location: United States
Using: AutoCAD2011, Inventor2011
Status: Offline
Points: 427
|
Posted: 11.Mar.2015 at 15:50 |
pretty sure some of those dims don't actually measure anything LOL Simply atrocious...
|
|
tulip3D
Senior Member
Joined: 23.Jul.2009
Location: United States
Using: AutoCAD2011, Inventor2011
Status: Offline
Points: 427
|
Posted: 11.Mar.2015 at 15:47 |
|
thats what im dealing with ↑
|
|
tulip3D
Senior Member
Joined: 23.Jul.2009
Location: United States
Using: AutoCAD2011, Inventor2011
Status: Offline
Points: 427
|
Posted: 11.Mar.2015 at 15:46 |
|
|
|
![CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]](/common/arkance_186.png "CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]")
Discussion forum
Data Link problems with Excel in 2010
Tweet
