I have created a table in excel and would like to sync it with sharepoint. I have downloaded SynchronizeWSSandExcel.xlam to allow me to publish and sync the table to sharepoint.

When I click the Publish and sync button I am prompted with a box with 3 sections; Address, name and description.

I fill these sections out but then get an error saying

Can not connect to the server

From reading similar posts regarding this topic, it would seem that what I enter into the Address and name section are critically important. However, the specifics of what exactly goes in there seems to vary from post to post.

Does anyone know exactly what I need to put into these boxes?

  • In address : SharePoint Site URL and in Name : Name of the list. Jan 5, 2016 at 13:02

1 Answer 1


Address : SharePoint Site url where you want sync it with Sharepoint Example : http://xyx.com/sites/yoursitename/

Name : Name of List which will be created in Sharepoint site with sync data
from excel. Example : MyTableSyncFromExcel

Description : Its the information which you want to provide list.

Please Note : It will work if you create a list from scratch.Existing SharePoint list can not be used.


In address you can put either http://cnet/en-uk/ or http://cnet/

Try this

  • Thanks for the reply Bhaskar! For the address, I do the full URL of the page where I want the table to be? Is the name of the list something I produce myself? Cheers
    – FrankWhite
    Jan 5, 2016 at 13:58
  • You just need to provide site name only and the list name. It will create a list in your SharePoint Site. Then you can add the list to the page wherever you want. Jan 5, 2016 at 14:01
  • when you say site name, that refers to the homepage of my sharepoint site? as opposed to a particular page. The name, then is just an arbritary name that I produce myself? Thank you
    – FrankWhite
    Jan 5, 2016 at 14:10
  • Yes you are right. But do not give complete home page url. You can remove the part after site name. You can refer example for site url in my answer. Jan 5, 2016 at 14:13
  • If you can share your home page url. I will tell you what needs to use exactly. Jan 5, 2016 at 14:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.