Custom VBA will be required to retrieve the properties and then write them to the header/footer. Our Excel template we have a Main sheet and then a sheet called "Data" which contains the named cells that the custom properties are linked to. Then on the main sheet where the document information resides the user simply makes the cell they to show the PDM revision letter "=Revision". And then "=Description" and "=DrawingNumber", etc. That way the user has very little to try and format.
That is an interesting idea. However some of our users have trouble with formulas in excel. The custom VBA doesn't scare me too much. I might be close to figuring it out through some excel forums.
Found the VBA Code in case anyone else is wondering this i
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Rev = ThisWorkbook.CustomDocumentProperties.Item("Revision")
ActiveSheet.PageSetup.LeftHeader = "Revision =" & Rev
Now for the fun of formatting.