Did you know that you need to have Microsoft Excel installed on your PC in order to use all of Inventor’s functionality?
Inventor 2019 requires a full local install of Microsoft® Excel 2010, 2013 or 2016 for iFeatures, iParts, iAssemblies, Global BOM, Parts Lists, Revision Tables, spreadsheet-driven designs and Studio animation of Positional Representations.
64-bit Microsoft Office is required to export Access 2007, dBase IV, Text and CSV formats.
Office 365 subscribers must ensure they have a local installation of Microsoft Excel 2016.
Windows Excel Starter®, OpenOffice®, and browser-based Office 365 applications are not supported. Earlier versions of Excel are not supported.
Inventor 2021 & iLogic changes:
Inventor 2021 now uses LibXL as the default engine for Excel based operations. This means that Inventor can be used without full Excel in certain instances. LibXL is faster than full Excel and can read and write Excel data, but it is not full Excel. LibXL cannot recalculate cell values.
Mike Deck of Autodesk shared a nice description of the changes on the Inventor Customisation forum:
See the original posting here: