Complete 2 way Sync Excel 2010 with sharepoint 2010 list
$10-30 AUD
Cancelled
Posted about 8 years ago
$10-30 AUD
Paid on delivery
Hi All,
I am trying to build the complete sync functionality between Excel 2010 worksheet and Sharepoint2010 list, in corporate environment
I have already install excel Addin, and able to publish and allow sync in excel.
The issues are:
1. I am not able to refresh excel sheet data ( Refresh all/refresh is grayed out) when a new item is added to SharePoint list
2. Not able to delete any rows in excel, as the message appears (" the ID column is read only column that can't be modified") possible because its a unique ID added when publishing the data to SharePoint.
Looking for complete solution: Either via VBA or any inbuilt functionality
-Sync Excel sheet to SharePoint List
-Update any changes(edit existing data, add new rows, delete new rows) in excel sheet to SharePoint list and Vice Versa via SharePoint list.
-Auto update sync
It will easy and quick for some who already played around with it or already have solution.
Thanks
Sam