Solidworks BOM to Excel
Solidworks BOM to Excel
(OP)
Hey there,
In SolidWorks I've managed to copy and paste link my BOM into excel. It's a nice feature being able to change the quantity of one item in the solidworks BOM and watch it change in the excel sheet. Now I have an old excel sheet with all of our parts and prices. I want to link that old sheet with the new BOM in my solidworks design so when I change the qty in the BOM it will change the QTY and price in the old Pre-Made excel sheet. This way I don't have to recreate a new excel sheet that has all the equations in it already.
Can anyone please help me with this and/or if it is even possible to do such a task.
In SolidWorks I've managed to copy and paste link my BOM into excel. It's a nice feature being able to change the quantity of one item in the solidworks BOM and watch it change in the excel sheet. Now I have an old excel sheet with all of our parts and prices. I want to link that old sheet with the new BOM in my solidworks design so when I change the qty in the BOM it will change the QTY and price in the old Pre-Made excel sheet. This way I don't have to recreate a new excel sheet that has all the equations in it already.
Can anyone please help me with this and/or if it is even possible to do such a task.






RE: Solidworks BOM to Excel
Chris
SolidWorks 11
ctopher's home
SolidWorks Legion
RE: Solidworks BOM to Excel
RE: Solidworks BOM to Excel
- - -Updraft
RE: Solidworks BOM to Excel
RE: Solidworks BOM to Excel
We'd like to have an assembly drawing and BOM in a solidworks drawing, then when we open the excel bom, it reflects the most current bom.
so.. what do we do in solidworks, what does that look like and 2) how do we get it to update excel.
thank you for your help.
Mike