I am working with SharePoint Server 2010 & one of my user groups is having an issue with a data connection within excel that I’m struggling to troubleshoot.
The ‘export to excel’ feature was used to create an export of the data columns in an InfoPath library. The user group has some additional local columns that they want to add for tracking purposes. We had created a view that sorted by date created. The issue is that when the excel workbook is refreshed to add new data from the InfoPath library, it shifts the source data but not the manually added information. We have tried sorting the library by different criteria to ensure all added records only get added to the bottom to no effect.
Has anyone else encountered this problem? What would be a potential fix for this?
