Back to FAQ
1213x
002654
Sonja von Bloh, M.Sc.
2019-03-19

Import of Model Data from Excel Using Formulas

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).

Import from Microsoft Excel - Settings
1 Import from Microsoft Excel - Settings

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).

Importing Table
2 Importing Table

Author

Ms. von Bloh provides technical support for our customers and is responsible for the development of the SHAPE‑THIN program as well as steel and aluminum structures.

;