×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel BOM

Excel BOM

Excel BOM

(OP)
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 .. sad

Thanks.

RE: Excel BOM

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.

RE: Excel BOM

(OP)

Quote:

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.

RE: Excel BOM

Go to the drawing tree and delete the BOM

Bradley

RE: Excel BOM

(OP)

Quote:

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)

RE: Excel BOM

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

RE: Excel BOM

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

RE: Excel BOM

Quote:

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.

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

RE: Excel BOM

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

RE: Excel BOM

(OP)

CorBlimeyLimey

Quote:

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

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

Thanks CorBlimeyLimey

RE: Excel BOM

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources