How do I find my CTB folder?

How do I find my autocad CTB folder? How do I add a CTB file to autocad?!

I posted an Autodesk Help style post on the subject previously here, but for a more condensed version do as follows:

  • Open autocad.
  • Type STYLESMANAGER
  • This opens the folder location of your CTB files
  • Copy the desired CTB files into this folder
  • Restart autocad
  • Your available plot styles will now have your new CTB files

stylesmanager
ctb folder

How do I insert an Excel spreadsheet into AutoCad?

Sometimes it can be very useful to have some additional data inside an AutoCAD drawing, so how do I insert an Excel spreadsheet into AutoCAD? It is pretty straightforward to set up and if done correctly, data that is inserted will automatically update when the original spreadsheet is updated within Excel.

 

Firstly, open the desired spreadsheet then select the data you want and copy it to clipboard.

In AutoCAD go to Edit > Paste Special

Inserting an excel spreadsheet into AutoCAD

In the dialog box, select Paste Link, then as Microsoft Office Excel Worksheet. If the radio bottom is grayed out and un-selectable, as below, then the data currently on the clipboard is unsuitable.

Inserting an excel spreadsheet into AutoCAD

Then click OK. The formatting of the original data should remain, and the data inserted will update inline with any updates made to the external Excel spreadsheet. This means that you won’t need to worry about updating two sets of documents if changes need to be made.

 


If you found this useful, why not check out some of my other AutoCAD posts?

How do I add a .CTB file to AutoCAD?

Free software for students

How to keep your XREF layers frozen

 

XREF layers don’t stay frozen in AutoCAD? Simple..

VISRETAIN

When VISRETAIN is set to 0 the changes to xref-dependent layers are valid for the current session ONLY! Turn it to 1 to have the changes save.

Taken from AutoCAD help files:

0 – The layer table, as stored in the reference drawing (xref), takes precedence. Changes made to xref-dependent layers in the current drawing are valid in the current session only and are not saved with the drawing. When the current drawing is reopened, the layer table is reloaded from the reference drawing, and the current drawing reflects all of those layer property settings.

1 – Xref-dependent layer changes made in the current drawing take precedence. Layer settings are saved with the current drawing’s layer table and persist from session to session.

How do I add a .CTB file to AutoCad?

This is actually very easy and straight forward, if you know where to look…

Firstly, you need to locate your .ctb folder on your computer that AutoCad references.

Menu > Tools > Options
Menu > Tools > Options

To do this, select the Tools tab, then click options at the bottom of the list.

Now under the Printer Support File Path tab, click Plot Style Table Search Path.

Plot Styles
Plot Styles
This shows you the folder you need. Now all you need to do is copy your .ctb file into the folder and restart AutoCad. Please feel free to share this page amongst your friends and colleagues!

 

Is there a question you would like to ask about CTB files? Leave a comment below.
You can find a condensed, 2016 version of this post here.