Some common reasons why a BOM may not import are:
-
Formulas or hyperlinks in the cells
-
Hidden columns/rows/sheets
-
Macros
-
Merged cells
While the import and mapping process is rather flexible and can handle many of the above situations on a case by case basis, errors may occur when they exist. A quick copy and paste as values into a clean sheet tends to be a quick fix for most scenarios.
*Note: A user cannot import a new BOM when an old BOM is still in the RFQ. Delete the original BOM first before entering a new BOM.