March 12, 2012
Linking Teamcenter Managed Excel Files With Solid Edge Embedded Client Files
In the Cache Assistant dialog select Download:
In the Download File dialog change the Files of type field to All documents (*.*):
Search for or locate the Item ID that contains the managed Excel file.
The Excel dataset is displayed in the Download File dialog:
Select the Excel dataset and select Open. The managed Excel file is downloaded into the Solid Edge cache:
In the Cache Assistant select the Excel file, right-click -> Open:
The managed file is opened in Excel.
In the opened Excel file select the cell value you want to link into a Solid Edge variable and right-click -> Copy:
In SEEC with the Solid Edge file opened that you want to link to the Excel file select Tools -> Variables:
In the Variable Table select the value you want linked to the Excel value.
Right-click -> Paste Link:
The Formula field should be updated to show the link to the managed Excel file, Sheet and Cell in the Solid Edge cache:
Close the Variable Table.
Save the Solid Edge file.
Either Upload or Close the Solid Edge file.
Depending you may be prompted to also Upload the Excel dataset as well:
The link has now been created between the managed Solid Edge and Excel objects:
Now the link exists, SEEC will bring down to cache the linked Excel file whenever the Solid Edge files is opened.