I have had to develop complex formulas in Excel toauto-populate the balloons & the corresponding item#. This isworking well for us. However, every time there is a change to anypart in the assembly, that changed part is moved to the bottom ofthe BOM & changed all the other # as well. If I understand theSW BOM correctly, it does not do this, but I have been havingtrouble getting the formulas to work. Any one know of a goodreference site or material? I have attached the Excel version weare currently using.

Thanks,
billSolidworksBill Of Materials