Your Best Source for CAD, CAM & CAE Articles




Home
| About | Submit Article

CAD, CAM & CAE Articles

Partners

CAD, CAM & CAE News

TenLinks.com

More News

 

 


 

  Exclusive Article    

Industry-Experts Cover
Products & Services You
Need to Know About.
Only on CADdigest.com.
Find Out More!

Insert Data from an Excel Worksheet

By Ellen Finkelstein, July 2, 2013
Originally published on EllenFinkelstein.com. Republished here by permission.

A reader asked how he could display data that was linked to an Excel spreadsheet. It might be easier to update the data in the spreadsheet or you might be keeping the data there anyway for other purposes. For whatever the reason, it can be very efficient to create a data link and display the data in a drawing.

Here you see a table with a revision history.

You can do this in a table fairly easily. Here are the steps. Below is a video tutorial of the same procedure.

  1. On the Home tab, in the Annotation panel, click Table.
  2. In the Insert Table dialog box, choose the From a Data Link option in the Insert Options section.
  3. Click the Launch the Data Link Manager Dialog button to the right.
  4. Click Create a New Excel Data Link option.
  5. Give the data link a name and click OK.
  6. Wait a couple of seconds until the New Excel Data Link dialog box opens. At the top, click the Browse button to browse for a file. Navigate to the Excel file and click Open.
  7. Back in the New Excel Data Link dialog box, choose which sheet you want to link to and also choose Link Entire Sheet, Link to a Named Range, or Link to Range. If you choose the latter, enter the range in the format A1::B12. As long as the Preview checkbox is checked, you’ll see a simple preview at the bottom.
  8. Click OK 3 times to return to your drawing.
  9. At the Specify insertion point: prompt, pick a point.

You can then select the table and make adjustments or format it.

Watch the video to see how these steps work. In the video, I also show you what happens when you change the data in Excel.

See All Exclusive Articles | Back to Top

Additional Information

Back to Top

About the Author

Ellen Finkelstein Ellen Finkelstein is a recognized expert, speaker, trainer, and best-selling author on AutoCAD, PowerPoint and presentation skills. Her articles have appeared in numerous magazines, newsletters, and blogs. She is the author of the AutoCAD 2013 and AutoCAD LT 2013 Bible. More...

See All Exclusive Articles | Back to Top