Factory asset ilogic not working since migrating to 2021

[MCCJohnPetty]

When we upgraded to Inventor 2021, we made sure that all of our factory asset masters were migrated.  Every since, the ilogic that drives them no longer works.  The ilogic accesses an excel sheet and pulls information that subsequently drives the asset design.

I am attaching the excel file and one of our many factory assets that we use on a constant basis.

Would someone be so kind as to look and see what in the world is going on?  I will be looking at some of our other assets to try to find a solution.  

Note: I am almost wondering if there is an issue with the array lists.

[MCCJohnPetty · Accepted solution]

I found the issue (thanks to all that viewed the post).  Under tools/options/ilogic configuration, change the Excel Options to "COM".  This allows for the "GoExcel" Object to:

Write to an embedded spreadsheet.

Use the GoExcel.Automation object.

Read (from Excel) a cell value that must be recalculated.

Normal functionality allows for the configuration to automatically select com to write to Excel and to use the Excel.Automation object, but will not switch automatically when trying to read from a cell.