One of the ways Civil 3D maintains a dynamic link between entities is through the use of Data Shortcuts.
Each data shortcut represents a “pointer” that identifies a shared object’s name as well as the drawing where the object is saved.
Select this arrow and many more options open up to you.
None of these options appears when you use the simple Paste Special technique listed earlier, but you can access these options at any time later on. Do you want the data types in your spreadsheet converted to Auto CAD text or would you prefer to retain the formula information?
This command isn't found in any menus (apparently it's top-secret), but you can find it in the Dashboard in the Tables control panel.
Here you'll also discover the new Datalink manager.
Are you going to permit writing back to the Excel spreadsheet from within Auto CAD?
By default, the linked tables insert with the table locked so you can change the Excel file and have it update in Auto CAD -- but not the other way around.
In the event you have a data shortcut in your project that has gone “dark”, there are a few things you can try in an attempt to restore the connection.
This wasn't the case, because these tables had low I. Once inserted, they never referenced back to the original Excel file, so if the Excel file changed, you had to erase the previously inserted Auto CAD table and reinsert an updated Excel file. AUGI members from around the world requested a true link between an Excel spreadsheet and an Auto CAD table, and they added this request to the famous Auto CAD wish list. Auto CAD 2008 brings with it the unexpected surprise of truly linked Auto CAD tables. You also can update this same table inside Auto CAD and have it update the Excel spreadsheet too (if desired). Don't use the standard Paste command because it will take us back to the less-than-intelligent process of the past.
You can insert an Excel spreadsheet into Auto CAD as a table object, and as the Excel spreadsheet is modified and updated, so is the Auto CAD table! We want to use Paste Special found under Auto CAD's Edit menu.
This default prohibits renegade CAD designers from accidentally changing the Excel file.
You must select "Allow writing to source file" before you can write back to the original Excel file.