Excel BOM

[jacek0841]

Rather very good at producing Drawing Based BOMs.

Now trying to produce my first Excel based BOM. Totally lost - where to start and how ? The INSERT sub menu has the EXCEL BOM dimmed.

I am sure the topic has been discussed on this forum in the past, but somehow I seem not to be able find proper threads (inspite of the search).

Could anybody give me some hints - like previous threads.

In the meantime - will keep searching .. :-(

Thanks.

 

[MElam]

You will not be able to insert an Excel based BOM if another BOM already exists in the drawing file. If no others exist, it should not be dimmed.

 

[jacek0841]

You will not be able to insert an Excel based BOM if another BOM already exists in the drawing file.

Yes, I know that. I produced a totally new assy from totally new parts (just for the exercise) and the Excel BOM is still dimmed.

 

[Standing]

Go to the drawing tree and delete the BOM

Bradley

 

[jacek0841]

Go to the drawing tree and delete the BOM

There is NO BOM - brand new parts, brand new drawing, using sample sheet from SW (just in case my company's template has "something" in it)

 

[ctopher]

There should be a separate forum on this topic. There are more questions about this than anything else within SolidWorks.

Chris
Systems Analyst, I.S.
SolidWorks/PDMWorks 05
AutoCAD 05
ctopher's home site (updated 06-21-05)
FAQ559-1100
FAQ559-716

 

[jacek0841]

After reading a couple of threads - should I consider an Excel based BOM's as the thing of the past ?

 

[ctopher]

Do a search here for "BOM".

Chris
Systems Analyst, I.S.
SolidWorks/PDMWorks 05
AutoCAD 05
ctopher's home site (updated 06-21-05)
FAQ559-1100
FAQ559-716

 

[CorBlimeyLimey]

should I consider an Excel based BOM's as the thing of the past ?

No ... all you need to do is select (highlight) a view before trying to insert an Excel BOM. Once a view is selected, the Excel option will no longer be dimmed.


Helpful SW websites FAQ559-520
How to get answers to your SW questions FAQ559-1091

 

[HeavenlySolid]

EXCEL BOM is dimmed because you have not click on the drawing on the page. It happened to me too just a few hours ago, I went crazy trying to undimmed it.

The I click on the view I just placed and boila!! EXCEL BOM un-dimmed.

Hope it helps

 

[jacek0841]

CorBlimeyLimey

No ... all you need to do is ...

Well, I guess, I am really !@#$%^&*!!

Thanks CorBlimeyLimey

 

[nthomas]

Having problem with custom columns on the excel BOM. I added columns and followed SolidWorks help to link the new column with the properties of the model. For example I added a CODE column. I have a CODE property in the model and have named it in the excel bom to match. When I bring the bom into the drawing the CODE is not filling in (it is blank). Any suggestions.

Thanks in advance,
NT/GL