locked
Cant export SharePoint document library to Excel RRS feed

  • Question

  • "to export a list you must have a windows sharepoint services-compatible application"

    I get this message when I try to export a Document library to a spreadsheet. The information in the list came from an infopath form.

    After I click ok to this error message my browser attempts to download owssupp.dll. I'm not sure what this is. I tried to do the same from another pc by giving that user full permissions but I got the same problem.

     

    Can anyone help me? I'm very stuck. Thanks in advance!

    Ben


    Ben Taliadoros Software Engineer
    • Moved by Mike Walsh FIN Friday, December 17, 2010 1:45 PM This question has NOTHING to do with Excel Services. (From:SharePoint - Excel Services (pre-SharePoint 2010))
    Friday, December 17, 2010 11:45 AM

Answers

  • Under control panel you will get add or remove programms and under that you will get MS Office 2007, Click on Change button it will pop up a screen with "Add or remove features" and "repair" option

    Select "Add or remove features" and click continue

    In the next screen you will get Office Tools option, expand it and find for Windows Shareoint Services Support component

    click on the dropdown arrow and select "Run on my computer" which will install Office compatible tools for SP

    After that try to export in spread sheet.

    Also one more thing before performing above steps to check proxy settings and if its there try to disable proxy and check


    Regards, Pratik Vyas | SharePoint Consultant |
    • Marked as answer by Peng Lei Thursday, December 23, 2010 7:01 AM
    Friday, December 17, 2010 1:32 PM

All replies

  • There may be number of reasons,

    Do you have excel installed on your machine ?

    Which version of Office you are running ?

    Is there any proxy enabled ? Check after disabling proxy

    at last try to repair office and add SharePoint Office compatible component added.

    Also you can check

    http://social.technet.microsoft.com/Forums/en/sharepointgeneral/thread/060891d4-594b-4fa9-a161-e69a35d92da4


    Regards, Pratik Vyas | SharePoint Consultant |
    Friday, December 17, 2010 12:15 PM
  • Thankyou, yes i do have excel on my machine, i am running office 2007 and im not sure what you mean by repairing office and the sharepoint compatible component.

     

    Please explain in Laymans terms, thankyou


    Ben Taliadoros Software Engineer
    Friday, December 17, 2010 12:56 PM
  • Under control panel you will get add or remove programms and under that you will get MS Office 2007, Click on Change button it will pop up a screen with "Add or remove features" and "repair" option

    Select "Add or remove features" and click continue

    In the next screen you will get Office Tools option, expand it and find for Windows Shareoint Services Support component

    click on the dropdown arrow and select "Run on my computer" which will install Office compatible tools for SP

    After that try to export in spread sheet.

    Also one more thing before performing above steps to check proxy settings and if its there try to disable proxy and check


    Regards, Pratik Vyas | SharePoint Consultant |
    • Marked as answer by Peng Lei Thursday, December 23, 2010 7:01 AM
    Friday, December 17, 2010 1:32 PM
  • tried it, will retry the export. how do i disable the proxy?

     

    Thanks for your effort


    Ben Taliadoros Software Engineer
    Friday, December 17, 2010 3:02 PM
  • you will get proxy settings details under Internet Explorer Tools > Internet Option > Connections > LAN Settings
    Regards, Pratik Vyas | SharePoint Consultant |
    Friday, December 17, 2010 3:10 PM
  • it was already disabled. any other suggestions? i can get the data into excel but only after opening a file called owssvr.iqy. i dont want my users to have to go through this every time. Thanks for the help so far though.
    Ben Taliadoros Software Engineer
    Friday, December 17, 2010 3:27 PM
  • This is the MS Office Excel Security notice to establish connection with SharePoint

    It asks whether you want to allow blocked content or not , you can disable it from Excel options > trust center


    Regards, Pratik Vyas | SharePoint Consultant |
    Friday, December 17, 2010 3:37 PM