Reputation: 37
I have a SharePoint 2010 server which I'm using to host a document library containing InfoPath forms. The forms are saving as XML files to the library and can be opened and viewed as completed "Forms".
I've connected the library to Excel 2010 using the "Export to Excel" details , and can refresh the data to pull down new form information however it only pulls down the name of the form and column headings for the library (which i guess it would as I've not changed any settings)
How do I go about setting this up to download the completed form data into a new row in the excel sheet?
e.g
User Completes Form >> Completed form is uploaded to SharePoint >> Tracking sheet is opened in excel >> New data is downloaded and added from the form library
Upvotes: 0
Views: 619