OLE (Excel to AutoCAD) problem

[anicholls]

Hi,
I have recently installed AutoCAD 2010 and am having problems with copying and pasting from excel.
AutoCAD 2004 worked beautifully when copying and pasting tables of text from Excel to AutoCAD, whether using 'paste' or 'paste special'.
Installed AutoCAD 2010, now when using 'paste' or 'paste special' in AutoCAD 2010, I get a 'OLE Text Size' notification.
I am required to choose OLE Font, Point Size & Text Height but only the Text height can be altered.
Selecting the default (2.4694) appears to be about average but when zooming in and out, the text size alters itself and when printing, the text size is all messed up.
Now AutoCAD 2004 is doing the same thing.
Is there a way to get around the OLE text option or turn it off altogether?
Thanks in advance.

[vtmiii]

first congrats on first post and welcome to AUGI.
second, we had the same problem. our solution was to use a third party software called
XL2CAD. its farily inexpensive at doftsoft.com.

i know there is a way to get excel to work with autocad, but i can't seemed to get a good ansewer.

[CADKid]

Welcome, Try typing "datalink" at the command line and follow the steps in the dialogue boxes that follow. This is a new feature that works with Excel files very nicely and helps manage the files when they are changed. You can google it and get tons of stuff. Here are a few links I found that might help.

http://heidihewett.blogs.com/my_weblog/2007/04/good_question_a.html

http://docs.autodesk.com/ACD/2010/ENU/AutoCAD%202010%20User%20Documentation/index.html?url=WS73099cc142f48755f05f5210d9d6cf355-7fde.htm,topicNumber=d0e163032

http://autocad.autodesk.com/?nd=search_everything&q=excel

Good Luck