I am using The Microsoft Excel Addin to synchronize Excel to sharepoint list. I followed the below article http://msdn.microsoft.com/en-us/library/bb462636(v=office.11).aspx But my formula in the excel are removed, so when i try to update, all my formulas have been removed. Is there any way i could retain this formula, so that i can update the next time after making some change Thanks Lakshman

The URL you quote is to a 2003 SharePoint product article. Please therefore confirm that you are using either WSS 2.0 or SPS 2003. Moderator pre-SP 2010 forums (where the default is the 2007 products) SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters

Hi am using Moss 2007Lakshman

In that case you should look to see if there is a MOSS 2007 equivalent of that article. It will have office12 in the URL not office11. You might be able to find it by going to the SPS 2003 article and looking at the right-hand side of the page for a link to "other versions of this article" (or similar wording).SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters

Hi, It will be great if you provide me a URL where i can search about this. I dont get you what you have said above. Thanks in AdvanceLakshman

Hi, There is a Add in for Microsoft Excel, where in which u can synchronize with the sharepoint list. All u have to download the Addin from http://www.microsoft.com/en-us/download/details.aspx?id=9345 And then open the excel, from the Design tab, click Publish and allow Sync Enter the SharePoint site URL, list name and description Click Publish That's it! You can now update either the Excel spreadsheet or SharePoint list and it will be in sync. Make sure you manually sync Excel with SharePoint by right-clicking within the Excel table and select Table | Synchronize with SharePointLakshman

Hi, There is a Add in for Microsoft Excel, where in which u can synchronize with the sharepoint list. All u have to download the Addin from http://www.microsoft.com/en-us/download/details.aspx?id=9345 And then open the excel, from the Design tab, click Publish and allow Sync Enter the SharePoint site URL, list name and description Click Publish That's it! You can now update either the Excel spreadsheet or SharePoint list and it will be in sync. Make sure you manually sync Excel with SharePoint by right-clicking within the Excel table and select Table | Synchronize with SharePointLakshman