Working around Excel's eight-level limitation

Excel's outline hierarchy is limited to eight levels. When the selected Teamcenter hierarchy exceeds that limit, all objects are exported to an unstructured file. Excel's Outline features are disabled in this file.

Data cannot be imported if the Outline features are disabled on Excel's Data tab.

To work around this limitation, you can:

1. Export the structure to a standard Excel file by selecting Static Snapshot in the Export to Excel dialog box.
2. Edit the static output file to match the object and relationship hierarchy in the structure.
3. Initiate the import process from the edited static file.

Note: Associate the disabled output file's control sheet with the edited static file.