Hide Table of Contents

Design Table Configurations

A design table allows you to build multiple configurations of parts or assemblies by specifying parameters in an embedded Microsoft Excel worksheet.

The design table is saved in the model document and is not linked to the original Excel file. Changes you make in the model are not reflected in the original Excel file. However, you can link the model document to the Excel file if you wish.

To use design tables, you must have Microsoft Excel installed on your computer.


You can control the following items in a part design table:
  • dimensions and suppression state of features, size of Hole Wizard holes
  • configuration properties, including part number in a bill of materials, derived configurations, equations, sketch relations, comments, materials, and custom properties


You can control the following parameters in an assembly design table:
  • components – suppression state, referenced configuration, fixed or floating position
  • assembly features – dimensions, suppression state, size of Hole Wizard holes
  • mates – dimensions of distance and angle mates, suppression state
  • configuration properties – part number and display in a bill of materials (when used as a subassembly), derived configurations, equations, sketch relations, comments, custom properties, display states

Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

Subject:   Feedback on Help Topics
Page:   Design Table Configurations
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:


We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again

Web Help Content Version: SOLIDWORKS 2014 SP05

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.