Import spreadsheet from Excel 2003 to Sharepoint 2007 generates error 'Cannot connect to the server at this time..." RRS feed

  • Question

  • Hello,

    I'm trying to use the "Import spreadsheet"-list function in sharepoint but I get the error "Cannot connect to the server at this time. Your list cannot be published."

    There are countless threads out the with this problem but I've found no solution that seems to be working for me.

    I'm using

    Excel 2003 (11.8347.8405) SP3
    Sharepoint 2007
    WSS 3.0
    IE 8.0

    I've tried the following fixes without any success:

    Modifying the EXPTOOWS.XLA. Didn't work. The file didn't contain the rows mentioned in the fixes and adding the "lVer = 2" just made the add-in break on that row when attempting to upload a spreadsheet.

    Adding the site to Trusted sites in IE and Lowering the Trusted sites-security setting to Low.

    Uploading directly to the root-site.

    Making sure the HTTP Header 'MicrosoftSharePointTeamServices' in the IIS Manager is set.

    Any help is appreciated.

    Thursday, July 10, 2014 6:57 AM