Here is what I have done and what I am trying to do. I have a SharePoint list that I exported to Excel and then created a connection. When I add an item in the SharePoint list the new items are added to the excel spreadsheet automatically or after I click "Refresh" in excel.
The problem is that if I add items in the excel spreadsheet they do not appear in the SharePoint list as they had done going to the list first. Do I have to create a second connection for items that are added to the excel spreadsheet to appear in the SharePoint list?
Can anyone guide me?