AnsweredAssumed Answered

Design Tables + Sorting Values

Question asked by 1-RKQUKS on May 31, 2010
Latest reply on May 31, 2010 by Josh Brady

Hi,

Just a question regarding SolidWorks 2010 + Excel and design tables.

 

I have built a design table in excel which drives configurations in SW.

 

Although in excel the sort function order the list correctly, this order does not transfer to the values set in Solidworks.

 

EG. in excel the fastner:

 

M10 x 1.25 x 70 is above

M10 x 1.25 x 100

 

But in SolidWorks. the 1 in 100 sequentially defalts above the 7 in 70.

And put the configuration order as per

 

M10 x 1.25 x 100

M10 x 1.25 x 70

 

Any ideas on how to over ride this and have the configuration list represent the order as per the excel file.

 

Thanks in advance,

Mark. 

Outcomes