Mapping from PLM to Excel

To enable the value of an Microsoft Excel cell to be automatically updated with the value of an PLM attribute, you must define a property attribute, a macro, and a function in the Microsoft Excel template. You must insert the function in the cell that must be updated with the property attribute value. The property will be updated with the PLM attribute value. The macro will pass on the PLM attribute value to the cell in the workbook.

To map PLM attribute value to a cell in a workbook:

  1. In the File menu, select Properties.
  2. In the Custom tab of the <Template name> Properties dialog box that appears, proceed as follows: