I am trying to create a Bill of Materials to go along with exploded assemblies of my company's products in Inventor Publisher. To do this I would like to import the BOM from Microsoft Excel into Publisher and have the imported file update in Publisher as I make changes to the original Excel file. Ideally I would like the balloon attached to each part in the exploded assembly to update as well if its item number has been changed in the BOM excel file, but I know this may be a stretch.
Does anyone know if this is possible in Inventor Publisher? Any help would be appreciated.