I have an Excel spreadsheet and I want to use it to trigger a work flow ... BUT ... I don't want to just use the creation or modification of it to trigger the work flow ... I want some data in the sheet to trigger it.
I followed some How-To's and was able to get to the point where I set up a Site Column and associated it to a Custom Content Type (i.e.: my Excel sheet) and when someone creates a new document this is loaded with the ability to manually enter the value in
the Document Properties bar that appears. Great ... but why would I want to manually enter the value again when I have already have it in a cell below.
I thought, OK a little more work to do and I am done.
So, after some research, I learned that I have to create, and link, a Named Cell Range and Custom Field in my Excel document and then expose that to SharePoint. I was referenced to this article (http://tinyurl.com/29l98rl) and performed the steps
as outlined ... and thought, "Great that was easy ... I am done !!"
Well ... that wasn't quite true. After testing this out I soon realized that the data in the cell was not being populated into the Site Column and thus was not being populated back to SharePoint.
So I went back and double checked it and am pretty sure that I d
View Complete Post