dynamically update sharepoint metadata from excel cell value

[brentcook]

I have an excel template that I keep in sharepoint. When I get a new client, I use the template to create a new file. I was really hoping to link a few cells in the file to the metadata in sharepoint either upon cell value change or saving the document. I linked them through custom properties, but that seems to do nothing. I've searched all over and found others have been struggling with it as well with no rhyme or reason as to why it isn't an option. Anyway, figured I'd post it here because anytime I have in the past you guys/gals crushed it. I've got a (VERY) basic understanding of VBA so any help would be greatly appreciated.

Thanks in advance!