cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Bi-Directional update of Windchill PDMLink Attributes to Excel Spreadsheet cells

Bi-Directional update of Windchill PDMLink Attributes to Excel Spreadsheet cells

Today Windchill PDMLink users create Documents with content format as an Excel spreadsheet. Even though information is available in Excel spreadsheets, users have to fill in again all mandatory attributes on New Document Creation screen. It will be a great enhancement if "Bi-Directional update of Windchill PDMLink Attributes to Excel Spreadsheet cells" is implemented. So during Checkin, Checkout process the values in Excel spreadsheets and Windchill PDMLink attributes can be kept in sync. If this can be done with Microsoft Word or PPT etc.,. especially for WTDocuments it will be great.  Most of customers may have lot of custom attributes on WTDocument, this will save time for users to type in only once rather than twice.

Did anybody implemented this customization, can you please share some details ?

4 Comments
ScottMorris
16-Pearl

Document properties are only available in Microsoft Word and Microsoft Excel, not Microsoft Powerpoint. Are you using Windchill Desktop Integration to link the attributes and their values between the document and Windchill?

cnallani
5-Regular Member

Thanks for information on Powerpoint. Yes, we are using Desktop Integration. Is it possible to link Custom Attributes between Excel and PDMLink?

ScottMorris
16-Pearl
Wayne_Beck
11-Garnet

@ScottMorris My understanding is this is currently a one way street.  I have followed the link above and cannot get my excel values to populate meta data fields in windchill.  It could be I am missing something.