Cant export SharePoint document library to Excel
"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! BenBen Taliadoros Software Engineer
December 17th, 2010 6:48am

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-e69a35d92da4Regards, Pratik Vyas | SharePoint Consultant |
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2010 7:19am

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, thankyouBen Taliadoros Software Engineer
December 17th, 2010 8:00am

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 checkRegards, Pratik Vyas | SharePoint Consultant |
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2010 8:36am

tried it, will retry the export. how do i disable the proxy? Thanks for your effortBen Taliadoros Software Engineer
December 17th, 2010 10:06am

you will get proxy settings details under Internet Explorer Tools > Internet Option > Connections > LAN SettingsRegards, Pratik Vyas | SharePoint Consultant |
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2010 10:14am

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
December 17th, 2010 10:31am

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 centerRegards, Pratik Vyas | SharePoint Consultant |
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2010 10:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics