Lets assume the following:
I have an excel spreadsheet set as the template for a document library. There is a cell on the excel sheet in which the user manually enters a reference number. I'd like the document information panel to pick up this reference number from the cell, publishing
it in a column on the document library when saved.
Alternatively the reference number could be manually typed into the document information panel. This would require the cell to lookup and retrieve the reference number and display it on the sheet (for printing purposes).
Does anyone know if this is possible?
Thanks.
Version: SharePoint 2007 Enterprise
Users: Win XP / Win 7 - Office 2007 / 2010