Connect Multiple SharePoint Sites

Open the SharePoint Data Doc Settings form, select New and add the URL for your SharePoint site, removing the default.aspx part, however leaving the "/" at the end of the URL.

Example: http://MySharePointDomain.com/Sites/SiteName/

Add your Username and Password as used when you connect to SharePoint with your browser. If you need to enter a Domain name for your site, do so here. Normally, if your user name is of the format username@domain.com you will not need to enter a domain, so leave this field blank.

Click the “Test Connection” button.

If the connection is successful click the “Save & Exit” button and you are ready to start adding data sets. If your connection test fails then check your details and retry until you get a Test Successful message. You are all ready to go.