AnsweredAssumed Answered

Custom Excel BOM

Question asked by Mark Greenwell on Apr 30, 2015
Latest reply on May 1, 2015 by John Stoltzfus



I am for the 1st time trying to set up an Excel based BOM as opposed to the standard SolidWorks BOM.


I have fount the Excel BOM templates and thought I could just edit one to suit.


While some properties now appear on the BOM some are taking the wrong information.


Attached are some screen shots.


I have an assembly with multiple part all with custom properties.


I want the BOM to take the information from these custom properties,

I cannot figure out how to link the Evaluated Value to the BOM, these would be in this screen shot, Length (500) and Section Size. (Plt 30*165)




This is what appears on the BOM, which are Value / text expression for length and nothing for the Section Size.


I guess it could be how I have set the Excel file up but not sure what I have done wrong.




Also attached is the edited excel file.


Could some one please explain what I need to do.




Mark (SolidWorks 2015 sp2.1)