I am using SW2007. Does anyone know how to overide the quantity in an excell based BOM and have SW retain the changes. We use materials in our assemblies, like solder and flux, that I would like to show up on our BOM as AR (As Required). I currently just save a blank part with our material part number and insert that into our assembly, so the quantity shows up as 1. Any help would be appreciated.