Skip to main content

Nitro-BOM Performance Tips

Practical advice for improving Bill of Materials automation export and import performance with Nitro-BOM.

Assembly Preparation​

  • Simplify before export: Use simplified representations to reduce the number of components loaded
  • Close unnecessary windows: Each open Creo window consumes memory
  • Use lightweight representations for components you don't need full detail on

Excel Configuration​

  • Close other workbooks: Excel performance degrades with many open workbooks
  • Disable auto-calculate: Set Excel to manual calculation mode during large imports
  • Use 64-bit Excel: For assemblies with 1000+ components, 64-bit Excel handles memory better

Export Optimization​

  • Export only what you need: Use parameter filters to limit exported data
  • Avoid exporting drawings simultaneously: Export models first, then drawings separately
  • Use incremental exports: For repeat exports, only export changed components

Import Best Practices​

  • Validate data before import: Check for blank cells, invalid characters, and data type mismatches
  • Import in batches: For large assemblies, import changes in groups of 100-200 components
  • Save frequently: Save your Creo session between import batches

Troubleshooting Slow Exports​

SymptomLikely CauseFix
Export hangs at startCreo regenerationSimplify assembly first
Excel freezes during exportToo many formulasDisable auto-calculate
Export takes >10 minutesLarge assembly + all parametersUse parameter filters
Memory errors32-bit ExcelSwitch to 64-bit Excel