I always have to do this in 2 imports
1. Mark a custom checkbox on all items containing the inactive item
2. Export all items AND their complete BOMs that contain the custom checkbox in step 1
3. Remove the inactive item manually in Excel
4. Import to the BOMs using the overwrite sublists function as @Suitestallion suggested