specifying yor design table

I believe you can link a design table to another spreadsheet.

As for the first problem, all the dimensions should be in one row. You can format the dimension names and set alignment to 90deg. to make them take up less space.

I am surprised that there is no repetition of dimensions in your truss.

You can use multiple Excel sheets in design tables! This way you can have a table formated the way you want, and a design table in SW format that simply copies cells from the other sheet. All you have to care is to activate the sheet with the SW design table before saving/closing. Philippe Guglielmetti -

Hello Hendrik,

Look the excel documentation for Transpose function. You could fill in the actual dimension values in single or multiple columns instead of row, and you could use Transpose function to turn the column 90 degrees to the way SolidWorks wants them to be.

Kind regards, Heikki

The other thing you can do is to write a macro to copy specific dimensions from one or more sheets to the design table sheet used by SolidWorks. This allows you to use more of the features of Excel such as forms, dialogs, VB, etc and then copy and activate the correct sheet before exiting.

Tony