locked
Synchronizing Excel and Sharepoint List RRS feed

  • Question

  • 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
    Thursday, April 21, 2011 7:19 AM

Answers

  • 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 SharePoint


    Lakshman

    • Marked as answer by Gachu16 Thursday, June 7, 2012 11:12 PM
    Wednesday, June 6, 2012 10:41 PM

All replies

  • 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

    Thursday, April 21, 2011 8:04 AM
  • Hi am using Moss 2007
    Lakshman
    Thursday, April 21, 2011 8:12 AM
  • 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
    Thursday, April 21, 2011 8:20 AM
  • 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 Advance


    Lakshman
    Thursday, April 21, 2011 8:25 AM
  • 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 SharePoint


    Lakshman

    • Marked as answer by Gachu16 Thursday, June 7, 2012 11:12 PM
    Wednesday, June 6, 2012 10:41 PM