Excel to SharePoint Synch

hi i want to Synch Excel data to SharePoint list and i did it using the  link Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists

now when i open the workbook again and update any fields and try to synch the option to Synchronize to SharePoint is missing

any idea on this.

August 27th, 2015 11:19am

Hi Alen,

Are you using the add-in for SharePoint 2013 and Office Excel 2007?

From the KB:

https://www.microsoft.com/en-us/download/details.aspx?id=9345

This download works with the following Office applications:
2007 Microsoft Office system
Microsoft Office Excel 2007
Microsoft Office SharePoint Server 2007

This download also works with Microsoft Windows SharePoint Services 3.0.

I am not sure if it could work for SharePoint 2013.

As a workaround, I suggest you import your Excel data into Access, then export the data from Access to SharePoint. If you want to update the workbook, you can update it in Access, then sync it to SharePoint.

About syncing Access to SharePoint, you can refer to:

https://support.office.com/en-nz/article/Build-and-publish-an-Access-database-to-SharePoint-e68bf007-410c-43b2-bf21-322ddbcf5411

Thanks,

Wendy

Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2015 2:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics