See this thread for more https://forum.solidworks.com/message/365837#365837
I got it to work with VBA code, you can do it before print or after save.
I used after save command which meant that the variables would not update till someone opened it and saved it. Which could work depending on your situation, but unfortantely it did not work for us.
There is probably another way to do it, but I decided to take an easier path and just make our excel templates have the revision info on the first row and everything else goes below.
I agree with you - Excel doesn't play as well with custom properties as Word does.
I don't believe there is a way to add an EPDM variable to the header or footer in Excel. In Excel, you can link a cell to a property by giving the cell a name that is the same as the custom property then linking the value of the custom property to the contents of the cell. The problem with the header or footer is that the content is not linked to a column/row location that can be named. It looks like you can link to things like the filename, sheet name, current date, etc. but that may be all.
You could do a search for Excel help on the web. There are a lot of resources from users that are really familar with Excel.
I have searched high and low for Excel help online which has been very little in regards to what I wanted to do. I will be adding the Revision info on the first row as well. Hopefully EPDM 2014 will have more tools for controlling MS files.
Thanks for the help.