I want to give the link between excel file to Bom in solidworks... I used excel based Bom but if i want to change the data in excel file then that data should be updated in solidworks BOM .. Is this possible in Solidworks 2013... plz help me
Santhosh, once you insert a excel based BOM into drawing then that excel is embedded into the drawing and there is no link between and external excel file and BOM inserted into the drawing. for any changes made to external file (aka template), you need to re-insert the BOM.
When you use "Excel Based BOM" then you're using an excel file BOM template and this set the BOM embedded into the drawing sheet as excel. And if you double click on the excel BOM in the drawing then you should be able to make the changes you need.
But in case you change the excel BOM template, then I believe you need to reinsert the table using the new template.
Actually Here I want to change the contents in excel bom but This contents are not updated in the solidworks BOM table....
How are you changing them? Can you attach one file and list the changes you need?
I have attached my file...
Thank you very Much .......
olá gostaria de saber se você pode me ajudar!
tenho uma planilha para inserir no solidworks e resgatar informações na BOM de corte e soldagem.É possível?
Can't we use OLE (Insert Object), which are linked ?
Yes we can use that but that is different from Excel based BOM.
I am currently trying to automate design of tanks for storing liquids, those start from 200 ltr. to 45,000ltr.
There are many parts and features, causing a huge file size and many dimensions to be cross linked between those parts.
Besides that I have team of people who do estimation, prepare quotes, have knowledge of Excel but not SolidWorks.
So I am making the tank as a multi body -single part file (No assembly), this reduce my file size & cross linking of many common data between parts, now its design table cells will be tied up to cells in external Excel sheet (second sheet).
Based on what options are selected on the first external Excel sheet, the Excel will do relevant calculations and update values on second sheet (to which the cells of Design table is tied)
But as it is a single part in SolidWorks, it will not produce a BOM in SW, so I thought of making the BOM in Excel it self and have my drawing updated as per the BOM in Excel.
So is it possible that I have a table in Excel, which is linked in the SolidWorks drawing sheet table and reflects the change in data of that external Excel file ?
You can format the external excel sheet such that it look like a BOM and then insert that directly into the drawing, Make sure file link option is checked.
Retrieving data ...