OLE text problem

[parasite]

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.
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.


My boss says 'There are no problems, only opportunites to prove yourself'.
I remain respecfully sceptical.

 

[hdp]

You can use the "Insert...OLE object" option from the "Insert" menu. Then use "Properties" command to set size and plot quality. Monochrome seems to work best for me. Also, I have found that when opening a dwg with an embedded Excel object, the object is often scrambled IF that object is ALSO open in Excel when the dwg is opened.

 

[IFRs]

Also, don't close Excel before saving the CAD file!

 

[chicopee]

Is your printing done in model or paper space?

 

[parasite]

Hi all,
I resolved this over the weekend; it turned out to be a very simple issue.
The excel document used font size 7.
This is not a ‘normal’ font size and must be summarised by AutoCAD.
AutoCAD 2010 cannot summarize it correctly for reasons I do not know.
Resizing the font in excel to 8 solved the problem completely.

Thanks to all who tried to help out.

My boss says 'There are no problems, only opportunites to prove yourself'.
I remain respecfully sceptical.