OLE is “Object Linking & Embedding” and it is pretty powerful. If you have an excel spread sheet or an image that resides outside of AutoCAD and you need these files inside of AutoCAD, adding these objects as an OLE object lets you insert them in your drawing and they can retain a link to the original file so that any updates that are done to the original file will also be shown in the AutoCAD file. For today’s tip, we will insert an excel spread sheet as an OLE object and also make an adjustment so that it will print/plot. The silly thing is that by default the settings for OLE objects are such that they might not plot.
- Have an excel spread sheet saved somewhere that AutoCAd can find it either on your hard drive or on a network location
- Click the “OLE Object” button that is in the “Date Link” panel on the “Insert” tab.
- Then select the “Create from file”
- Then browse to find the file
- Then, if you want the OLE object to reatin a link to the original file so that updates to the O.G. file (Original Gansta”;) are also shown in the AutoCAD file; click the check box next to “Link”
After the OLE object is in your drawing you will most likely want to move it into position. If you are not able to select the OLE object check the system variable OLEFRAME (shown below). The description of the system variable might be confusing – When it says that it is “shown,” that means that it is selectable…
Now that you have the OLE object positioned and you are ready to plot, change the setting of the “Plot Quality”
To do this:
- Select the OLE object
- Right click & select Properties to open the properties palette
Under the “Misc” Section in the properties palette, Click the ‘Plot Quality” section and select either “Low Graphics” or “Monochrome” from the list.
Shown below is the PDF that was created by using the Monochrome setting for the OLE object.