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: 10.Mar.2015 at 19:22 |
Hello all! New job new problems! LOL So here goes: I need to link an excel spreadsheet (parts list) to our CAD drawings to reduce confusion between purchasing and us desginers. I've figured out how to use data link to accomplish this, and it works. Problem is, whenever I 'update table data links', my nicely shaped parts list on the DWG gos all screwy, changing shape. My parts list is SUPPOSED to look like this: but then it looks like this after update: so what can I do to prevent this?
Edited by tulip3D - 10.Mar.2015 at 19:30
|
 |
tulip3D
Senior Member
Joined: 23.Jul.2009
Location: United States
Using: AutoCAD2011, Inventor2011
Status: Offline
Points: 427
|
Posted: 10.Mar.2015 at 19:23 |
Edited by tulip3D - 10.Mar.2015 at 19:31
|
|
John Connor
Senior Member
Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
|
Posted: 10.Mar.2015 at 22:05 |
|
If I remember correctly it is an option found in one of the DataLink dialog windows. I can't recall off the top of my head and I am not on my CAD computer at the moment.
|
"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 13:57 |
Still farting around with this. got it to not be so dramatic, but it still changes the column width...its not keeping things exact. If I dont get it perfect, folks here wont adopt it...'oh its fine the way it is, all manual an slow and problem prone'...i can hear it now lol.
|
|
John Connor
Senior Member
Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175
|
Posted: 11.Mar.2015 at 14:40 |
|
There's no crying in CAD! No moaning, bitching or complaining either.
Prior to using the DataLink feature were you inserting spreadsheets using the Paste Special command?
|
"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:42 |
Heck no. Dude here before me has no clue how things work...he just started using tables LOL before that all of the parts lists are text and lines... I'm essentially trying to teach an old dog new tricks, that never had a chance to know any tricks to begin with...he was a QA guy before being thrown to the CAD wolves...
|
|
tulip3D
Senior Member
Joined: 23.Jul.2009
Location: United States
Using: AutoCAD2011, Inventor2011
Status: Offline
Points: 427
|
Posted: 11.Mar.2015 at 15:46 |
|
|
|
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:50 |
pretty sure some of those dims don't actually measure anything LOL Simply atrocious...
|
|
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>>
|
|
![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
