For importing parameters from excel I once made an template which contains array-formulas.
I used to link this excel workbook to my inventor parts, but now I have to embed the spreadsheet in the Inventor parts (due to the usage of a data management tool).
To my big surprise, and disappointment, all the array-formulas I used are giving me a #VALUE! Error.
Does anybody know what's the reason of this error and if there is a possibility to correct this?
(Inventor 2010 Pro, Office Pro Plus 2010)
Matthijs