Mass change of scrap factor?

Yahoo Archive
1
I need to change the scrap factor for a component that is in over 500
bills of materials. Is there any automated process I can run to
simplify the enormous task. Can I export the BOMs to excel and make
changes then import them back?
2
I need to change the scrap factor for a component that is in over 500
bills of materials. Is there any automated process I can run to
simplify the enormous task. Can I export the BOMs to excel and make
changes then import them back?