Problem with inserting autocad drawing to excel

[u.karmacharya]

I see a stupid link while i copy my autocad drawing and paste it into excel cell. I don't know what the problem is, and how can i fix this?

[j.palmeL29YX]

What do you expect after "inserting AutoCAD drawing to excel"? What do you want to achieve? 

[u.karmacharya]

Actually, I am using mac os, and i expect to see the autocad drawing which could be adjusted to size and could be edited. 

[leeminardi]

One way to add an AutoCAD drawing  into Excel is the following:

1.  In AutoCAD set the visualstyle  to 2D wireframe.
2. If you are copying 3D geometry and you want hidden lines removed then enter the dispsilh command and set it to 1 and then give the hide command. If you are just working with 2D geometry skip this step.
3. Select the geometry you want to transfer.
4. Copy the selected geometry to the clipboard (with Windows this is with Ctrl-C, I do not know the Mac process for this).
5. In Excel do a Paste Special and choose the Picture (Enhanced Metafile) option.
6. You can move and scale the drawing as needed.

[u.karmacharya]

Its not working. It displays the link (/tmp/A$C7fafcbae.DWG). I dont know whether its the problem of autoCAD or excel?

[leeminardi]

What options do you see when you do the Paste Special?

The problem is most likely a Mac implementation limitation.

[pendean]

What is your AutoCAD for MAC version?
MacOS version?
Excel version?

[u.karmacharya]

I can only see Unicode Text and Text option only.

[u.karmacharya]

I am using Autocad 2018 for mac

MacOS Catalina

Excel Ver 16.36

[maxim_k · Accepted solution]

Hi Uddhav,

On Mac you cannot use copy - paste method to insert drawing data from AutoCAD to Excel, because this is OS specific functionality (AutoCAD for Mac and macOS cannot convert DWG data format to one of vector formats that Excel can read).
The only one way on Mac is to export drawing to PDF file from AutoCAD and then insert resulting PDF to Excel. Of course, you will not be able to edit inserted drawing by double-clicking on it as you can do on Windows side if you are using OLE technology.

[u.karmacharya]

Thanks for the information! I wasted my one whole day searching for the possible solution. It works smooth with Windows, I tried it.

[pendean]

>>>... It works smooth with Windows, I tried it....<<<
WE know: OLE Linking in WindowsOS is a Microsoft feature Apple did not buy into 😐