Good Question: AutoCAD/Excel Data Linking

Today’s good question comes from Gerald. He asked how he can write the changes he made in a linked AutoCAD table back to the Excel file.

In order to write data from the AutoCAD table back to the source Excel file, you must enable the "write" option within the data link.

1. Access the Data Link Manager (DATALINK command).
2. Right-click on the datalink that is being used by the table you modified and choose Edit.
   
3. If the Modify Excel Link dialog box is not already expanded, click on the black arrow in the lower right corner to expand it.
   
4. In the expanded dialog box, enable the option to Allow Writing to Source File and choose OK.
   
5. After you’ve edited the table cell contents, select the table, right-click and choose Write Data Links to External Source.
   

The answer I provided for this Good Question assumes you already know how to create a data link. You can learn more about data links in one of my previous posts and I tried to post even more detailed information in future posts.