Excel: Cell Value as Excel Document Metadata Property

Question

I know you can add custom Document Properties in Excel 2007.
see: http://office.microsoft.com/en-us/excel/HA100475241033.aspx#5

But I thought there was a way to pull a value from a cell as a custom metadata property without code. Maybe I'm searching for it with the wrong terminology. Maybe it has to be done as a Named Range. I know this can be done. Anyone know how?

Answer 1

I just used the Named Range for the value on the new metadata type. Then I made sure the same field was in the Sharepoint Library I was publishing to. Hope this helps!