Custom Excel BOM

[DUBOISM]

I am trying to create a custom Excel BOM which consists of several lines of information before the actual columns from which SolidWorks will propagate its information. When this BOM is inserted into a SolidWorks Drawing it shifts information, and duplicates information when CTL Q is selected. Can anyone advise as to what I am doing wrong or perhaps if this is a known bug? Any input is greatly appreciated. Thanks

 

[SBaugh]

That is because you removed the original columns. You Cannot remove these columns. You should hide the original columns keep the $END and insert Columns in front of (To the left of) the $END.

Regards,

Scott Baugh, CSWP

http://www.3dvisiontech.com

http://www.scottjbaugh.com

For all Newbie's - Welcome to the nerd herd!

faq731-376

 

[DUBOISM]

Do the original columns have to be the 1st columns, or can information be inserted above them?

 

[SBaugh]

I just simply hide them (Original Columns), then click the $END Column, then RMB and click Insert column.

Nothing can be entered above them as far as I know.

Regards,

Scott Baugh, CSWP

http://www.3dvisiontech.com

http://www.scottjbaugh.com

For all Newbie's - Welcome to the nerd herd!

faq731-376

 

[CorBlimeyLimey]

The design table can include additional columns or rows for information only (notes, intermediate calculations, and so on). Use the keyword $USER_NOTES in the header of any column or row that you do not want evaluated. You may use as many of these rows or columns as you need. However, you may not include rows or columns with empty headers in the middle of the table.

The above quote is from SW Help file design tables, user notes index. Although it does not state that the first column should not be used, the example picture shows the $USER_NOTES being in the 2nd or "B" column.

from (the City of) Barrie, Ontario.

I tried sniffing Coke once, but the ice cubes got stuck in my nose