Connections from Excel

MS Excel and MS Share point could be connected, as mentioned above.


Go to Data-> connections-> Properties (to check the below for the existing connection)
Definition -> Connection String:

Provider=Microsoft.Office.List.OLEDB.2.0;Data Source="";ApplicationName=Excel;Version=12.0.0.0


Definition -> Command Text:

<LIST><VIEWGUID>{7D06904D-3F2D-46CB-8E13-692848912564}</VIEWGUID><LISTNAME>{93A8F3BD-E4A1-4CE4-87A0-FFA66E87F3A9}</LISTNAME><LISTWEB>https://teams.aexp.com/sites/roadmapandstrategy/_vti_bin</LISTWEB><LISTSUBWEB></LISTSUBWEB><ROOTFOLDER>/sites/roadmapandstrategy/Lists/Automation</ROOTFOLDER></LIST>