locked
To export a list you must have a windows sharepoint services-compatible application RRS feed

  • Question

  • Hi

    I am using WSS 3.0 and Moss 2007,In my system Open Office is installed. So i am not able to open list as "Export To Spreadsheet", i am getting this error "To export a list you must have a windows sharepoint services-compatible application".

    Kindly help me for doing best.

    varma

    Thursday, December 30, 2010 12:49 PM

Answers

  • Although Open Office is compatible with the file formats used by Excel its not the same as Excel.  You need a copy of Excel 2007 at the same service pack level as SharePoint to be able to export to a Spreadsheet.
    Paul Stork SharePoint Server MVP
    • Marked as answer by Mike Walsh FIN Thursday, December 30, 2010 1:27 PM
    Thursday, December 30, 2010 1:11 PM

All replies

  • Although Open Office is compatible with the file formats used by Excel its not the same as Excel.  You need a copy of Excel 2007 at the same service pack level as SharePoint to be able to export to a Spreadsheet.
    Paul Stork SharePoint Server MVP
    • Marked as answer by Mike Walsh FIN Thursday, December 30, 2010 1:27 PM
    Thursday, December 30, 2010 1:11 PM
  • Agreed with Paul's advice but before that check is there any proxy available in your browser ?

    If yes then disable it and then try to export the list to Excel


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Edited by Pratik Vyas Thursday, December 30, 2010 1:28 PM add
    Thursday, December 30, 2010 1:27 PM
  • I marked this as an answer but I wonder about the requirement you mention of needing a copy of Excel 2007 at the same service pack level. As far as I know you need a copy of Excel 2007 but there's no service pack level requirement. Has this changed with the latest SPs?
    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, December 30, 2010 1:29 PM
  • Hi

    Which version of Open office i want to install in my system,all ready openoffice 3.0 is installed in my system, this version is not supporting  "List to Export To Spreadsheet" action, i am getting this error "To export a list you must have a windows sharepoint services-compatible application".

    Kindly help me....

    Varma

    Friday, December 31, 2010 4:03 AM
  • I don't understand why you are asking the same question again.

    It has already been clearly stated that having Open Office on the client is not enough for the List to Export to SharePoint option to work.

    The system looks out for Microsoft Excel. It is not enough to have any other application that can open Excel files.


    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
    Friday, December 31, 2010 6:58 AM
  • Actually Mike, I ran into this exact problem at a customers.  They had upgraded SharePoint 2007 to SP2, but not upgraded Office and were having issues with Excel import and a few other office integration things.  Upgrading Office to SP2 fixed the problems.  I figured it was because things like export require specific code both in SharePoint and Office.  At least with SP2 if you upgrade one side but not the other you can have issues.
    Paul Stork SharePoint Server MVP
    Friday, December 31, 2010 2:25 PM
  • I was struggling with this as well, but found a work-around (i.e. no upgrade needed):

    1. Open Excel 2007
    2. Select Data -> From Web
    3. Enter your SharePoint list URL (e.g. http://xyzcorp.com/Projects/EnterpriseICD10Site/Lists/IRAAD/All%20Items.aspx  )
    4. Expand any sections that you want in Excel 
    5. From within Excel, select Action -> Export to Spreadsheet
    6. Select Save and save to some location
    7. Back in Excel open the file that was saved  (selecting "all" files since it is a ".iqy" file, and BINGO

    Tuesday, December 13, 2011 7:51 PM
  • Hi there,

    I just saw this post what we did was to ensure that Excel Services under Site Settings for the site was activated, we received the same error until this was completed.  Hope that helps.

    Tuesday, February 14, 2012 4:19 PM