This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Wen importing to a modeled sheet, I am receiving the following error: Fail to execute structure changes. What does the error mean and how can I correct my import file?
This error message is returned when there are invalid values in the import file for modeled sheet imports. To correct the invalid values, you can search the Excel file for invalid cells and correct them with the proper values.
Search the file for the following scenarios:
Any strings that appear as errors such as #N/A or #VALUE!
Correct any of these occurrences by entering the proper formula or value
- Cells that contain formulas that are not fully evaluated such as =D5/D5 or =356/30.
- To correct simple references to other cells or simple mathematical functions that did not evaluate, you can copy the cell and then use Excels "paste as value" functionality to re-enter the formula.
If you have completed these steps and still cannot import the file, please feel free to open a Support ticket and attach the file in question.