Hi all, I have a document library of excel documents and I want to be able to get a column value form sharepoint into my excel document. For example, I have document named "A.xlsx" and the sharepoint item in list look like this: FileName Property1 Property2 ----------- ------------ ------------ A.xlsx ProptValue1 ProptValue2 I need to find a way to put the field's value of Property1 and Property2 into the associated excel document.... So in file A.xlsx, I would have a cell with value "ProptValue1" and another with "ProptValue2" For best scenario, I will need to updated the value each time the excel documents are opened. How can I doing this? Macro? VBA? sharepoint ? document properties... Thanks,

Although it can be easily achieved in Word with Quick Parts, you cannot do it in Excel user interface. You can use Excel VBA code to do so. Please read this for example: http://www.cpearson.com/excel/docprop.aspx