I know you can create a table in Excel and export that into SharePoint as a list. I want to know if you are capable of having two or more Excel files updating a single SharePoint list.
We want two different people to have the ability to update their own local Excel worksheet without getting it overwritten by the SP list. That way they each get to have an Excel worksheet with their own items and the SharePoint list gets all of the items. (They are both identical tables).