Greetings!
I have an Excel 2010 workbook that includes a table linked to my SharePoint 2013 site by a data connection. The SharePoint list feeds the table standard information that's managed on the SharePoint site, but I need the user of the Excel workbook to be able to enter text manually in the workbook to associate local information with the line-items coming from the SharePoint list. To do this, I've added extra columns to the end of the table. The user can enter information in the appropriate cells in the "extra" columns at the end of the table, but when I refresh the data connection, the addition of a new list item on the SharePoint side results in the user's manually entered text getting
out of alignment with the row it's supposed to be associated with.
Example
<tbody>
</tbody>
Then, if I add a new item to the list in SharePoint, for example, something that would appear between the original items 1 & 2, after refreshing the table, I get the following:
<tbody>
</tbody>
The table's data connection is set to insert rows for new items, and I could swear I had this working properly once upon a time...but I can't seem to make it work now.
I've read through several old posts on this sort of problem (mostly related to Excel 2003 and earlier, it seems), but the difference between those and this situation is that other have tried to enter "associated" text in regular worksheet cells adjacent to the query table, whereas with what I've got going on, the query table itself has been extended to encompass the adjacent cells where the user is to enter associated text.
Any thoughts on what would cause this?
Thanks in advance!
I have an Excel 2010 workbook that includes a table linked to my SharePoint 2013 site by a data connection. The SharePoint list feeds the table standard information that's managed on the SharePoint site, but I need the user of the Excel workbook to be able to enter text manually in the workbook to associate local information with the line-items coming from the SharePoint list. To do this, I've added extra columns to the end of the table. The user can enter information in the appropriate cells in the "extra" columns at the end of the table, but when I refresh the data connection, the addition of a new list item on the SharePoint side results in the user's manually entered text getting
out of alignment with the row it's supposed to be associated with.
Example
| Column 1(SP) | Column 2(Extra) | |
| Row 1 | Item 1 | |
| Row 2 | Item 2 | Text entered for Item 2 |
| Row 3 | Item 3 |
<tbody>
</tbody>
Then, if I add a new item to the list in SharePoint, for example, something that would appear between the original items 1 & 2, after refreshing the table, I get the following:
| Column 1(SP) | Column 2(Extra) | |
| Row 1 | Item 1 | |
| Row 2 | New Item 1.5 | Text entered for Item 2 |
| Row 3 | Item 2 | |
| Row 4 | Item 3 |
<tbody>
</tbody>
The table's data connection is set to insert rows for new items, and I could swear I had this working properly once upon a time...but I can't seem to make it work now.
I've read through several old posts on this sort of problem (mostly related to Excel 2003 and earlier, it seems), but the difference between those and this situation is that other have tried to enter "associated" text in regular worksheet cells adjacent to the query table, whereas with what I've got going on, the query table itself has been extended to encompass the adjacent cells where the user is to enter associated text.
Any thoughts on what would cause this?
Thanks in advance!
