Export traceability information to Excel in a structure view

Procedure

1. Open the structure with trace links in a structure view.For example, send a structure to the Structure Manager view, the Requirements view, or another structure view.

2. Choose Tools→Export→Objects To Excel.Teamcenter displays the Export To Excel dialog box.

3. Under Output, do one of the following:

For a standard Excel file that is not connected to Teamcenter, click Static Snapshot.

For an interactive live Excel file that is connected to Teamcenter, click Live integration with Excel (Interactive).

For a live Excel file that is not connected to Teamcenter, click Live integration with Excel (Bulk Mode). You can accumulate changes and later connect the file to Teamcenter.

To export the data to an Excel file that also contains import processing information on a separate sheet, click Work Offline and Import.

To check out objects while exporting to live Excel, select Check out objects before export. Note The checkout applies to all objects being exported. Use this option carefully if you are exporting a large set of objects or perhaps an entire product structure.

4. Under Output Template:

Select Export All Visible Columns to export all the columns in the applicable structure view. Note Verify the Trace Links or Trace Link column property appears in the structure view.

Select Use Excel Template to activate the template list. In the list, select the template that specifies the data that you want to export.

5. Click Copy URL. Note

Copy URL is unavailable if you select more than one object to export.

Copy URL is unavailable if you select any of the following dialog box options:

Work Offline and Import

Export All Visible Columns

Export All Objects in View

The export file is generated and the URL Generated message is displayed, confirming that the URL is in your Windows Clipboard and showing the URL details.

6. Click OK to generate the export Excel file.

Excel opens a temporary file. You can create a permanent file by choosing File→Save As in Excel to display the Save As dialog box. If you save a live Excel file, you can open it later in My Teamcenter to reconnect it to the database. Note Values that you cannot change in Teamcenter are unavailable in the cells of the live Excel file.