I have a list on SharePoint,and I would like to update that list from any excel sheet/file I create "Having same formatting of course". Can I achieve that?
I know that you can create a List on SharePoint from an excel sheet "Table Format" but I couldn't find any solution to sync SharePoint list from any excel sheet. Shall I do some scripting to achieve that ?
I'm using Excel 2010 and SharePoint 2010