As many of you realize, you can link ProjectWise document attributes to either a Built In or Custom Microsoft Excel attribute. However, what if you want to link that ProjectWise document attribute directly to an Excel Cell? Unfortunately, this process only works in one direction; from Excel to ProjectWise. If you would like to give it a try, you first need to setup the Microsoft Office Attribute Support Exchange Rules in ProjectWise (follow the ProjectWise delivered Help documentation). From there, you need to setup a linked attribute in Excel. The process for that is fairly straightforward:
1. Rename a Cell to something meaningful. For example rename cell “C2” to “Drawn_By”.
2. Open the Excel Advanced Properties option and click the Custom Tab
3. Match the Excel Custom Name to the ProjectWise Attribute Exchange Name
4. Next to Value field, enable “Link to content”. This will change the “Value” option to “Source”
5. Select the Cell Name you renamed in Step 1 above
6. Click Add. The new attribute should appear in the Excel Custom Properties page
1. Change the text in your renamed Excel Cell
2. Open the Excel Document Properties > Advanced Properties dialog
3. Highlight your Custom attribute and click OK
4. Select the “Update ProjectWise” command in Excel
5. Return to ProjectWise Explorer and view the document attribute. It should be updated with the new value.
As with many other ProjectWise commands, there are several configuration notes that you need to be mindful of, including but not limited to:
– This option only works going from Excel to ProjectWise : Unfortunately, I have not been able to get this to work coming from ProjectWise. You may be able to write a VB script to do this, however.
– Be mindful of the ProjectWise FREE command : As with all ProjectWise Exchange Rules, going to ProjectWise (from Excel, Word, MicroStation, etc.) will automatically write the updated attributes to the database. Therefore, if you happen to FREE the document afterwards, the new attributes are still set.