1157x
002654
2019-03-19

Question

When importing model data from Excel, only values are transferred instead of formulas. What can I do?


Answer:
When importing tables using the File → Import menu, select the "Formulas in tables and parameters" check box in the "Options" tab of the "Import from Microsoft Excel - Settings" window (see Image 01).
When importing tables using the Excel button of the current table, select the "Formulas in table" check box. If the parameters have not yet been created, it is also necessary to activate the "Parameters" check box (see Image 02).