locked
Sync - Excel & sharepoint list

    Question

  • hi All,

     

    I have download the Excel 2007 Add-in but unfortanelty i'm unable to publish & share my changes to the sharepoint list as i'm always getting the error message below:

     

    "Run-time error '-2147467259(80004005)':

       Cannot connect to the server at this time. Your table can't but published. "

     

    Also by searching I knew that in the Add-in Dailog box, there must exist the Rwsplist and when i followed the steps I didn't find it at all.

     

     

    so can you please help me in this please.

     

    Thanks

     

    Wednesday, December 26, 2007 12:41 PM

Answers

  •  

    hi,

     

    I have already resolved the error that I posted above. I think the error was because in the Address field of  the Rwsplist I also mentioned the List(http://servername/Lists/) & once I removed the connection worked.

     

    But if really would help I do have another issue which is that when I mention the name of the list(which is already built in the sharepoint) in the List field name of the Rwsplist dialog, the error states that the list is already in use & thus rename another one. As I want the changes always to appear in the same list in the sharepoint thus having one sharepoint list & one excel worksheet linked with it.

     

    The one I download is Excel 2007: Add-in Sync

     

    Thanks

    Saturday, December 29, 2007 2:41 PM

All replies

  • hi,

     

     Could you please let me know the add-in you have used to sync excel and sharepoint list?

     

    Thanks

    • Unmarked as answer by Mike Walsh FIN Monday, January 10, 2011 3:08 PM
    Saturday, December 29, 2007 9:55 AM
  •  

    hi,

     

    I have already resolved the error that I posted above. I think the error was because in the Address field of  the Rwsplist I also mentioned the List(http://servername/Lists/) & once I removed the connection worked.

     

    But if really would help I do have another issue which is that when I mention the name of the list(which is already built in the sharepoint) in the List field name of the Rwsplist dialog, the error states that the list is already in use & thus rename another one. As I want the changes always to appear in the same list in the sharepoint thus having one sharepoint list & one excel worksheet linked with it.

     

    The one I download is Excel 2007: Add-in Sync

     

    Thanks

    Saturday, December 29, 2007 2:41 PM
  •  

    hi,

     

    Please go thro' the below link for the details for publish & sync in Excel services:

    http://msdn2.microsoft.com/en-us/library/bb462636(office.11).aspx#Office2007SynchronizeSharePointListfromExcel_Updating

     

     

    Thanks & regards,

    Ramanan

    Friday, January 11, 2008 12:24 PM
  • Hi All,

     

    Just to share my experience with the list synchronisation feature. I had a similar error "Cannot connect to the server at this time." and tried everything to correct this error, from configuring security settings to reinstalling everything to using different versions of Excel. Finally found the fix:

     

    When you publish the URL of the SharePoint site to publish the list to, don't include "list" in the URL. For example, if you want to publish a list called myList to http://myserver, use the following parameters:

    Address: http://myserver

    Name: myList

     

    NOT

    Address: http://myserver/lists

    Name: myList

     

    I believe I'm not the only one who's stumbled on this. Hope it helps.

     

    Regards.

     

    Tuesday, February 12, 2008 4:18 AM
  • I too am having the same issue and am very interested in a fix if one has been identified. 

    Thursday, February 04, 2010 8:31 PM
  • I got the same error but was able to write to a new list.

    The error I received previously was really saying that the list already existed and could not be written to.

    Thursday, January 06, 2011 8:05 PM