none
sharepoint2010导出EXCEl出现错误

    Question

  • 你好,

    我有一个列表需要导出到excel中,点击“export to spreadsheet”后就要求下载“osssvr.iqy",打开点击"enable"后,就出现报错--- "Excel cannot connect to the SharePoint list"

    请教怎样解决?我已经是管理员权限,客户端使用的是Win7 32bit,IE10.0.5

    Sorry, I tranlated it into English

    Hello, I have one list from SharePoint need export to excel, when I click "export to spreadsheet" then request to download "owssvr.iqy" or "owssvr.dll". If I click "owssvr.iqy", and click "enable" for computer resure, then there got error "Excel cannot connect to the SharePoint list"

    So I want to know how to solve it. I already got "design" right, client computer using WIN7 32bits, IE 10.0.5.

    Another Question is how to process "owssvr.dll" after I download, where should this file put? it can solove the same issue?


    • Edited by Heart Zhang Monday, August 05, 2013 2:24 AM
    Sunday, August 04, 2013 9:29 AM

Answers

  • Copy and paste contents from link:

    Resolution:

    Generally we start our troubleshooting from the SharePoint side as what is wrong with my SharePoint site, Is there any problem in the SharePoint list, Does the Office which is installed on the machine is causing the problem ? Is there any site collection feature turned off? Is there any problem in the SP-Database? Problem with the IIS? so things are there by which we can think off but don't waste your time in doing all these things as I have done all these things and the resolution is quite simple which you can implement without any help.

    1. Open the Internet Explorer
    2. Tools
    3. Internet Options
    4. Advanced Settings
    5. Scroll downwards and reach towards the section named as "Security"
    6. CHECK FOR SERVER CERTIFICATE REVOCATION--which is by default checked
    7. Unchecked it
    8. Apply and Ok
    9. Close all the internet explorers (IE) and open your SharePoint site in a new IE i.e. Browser/Explorer
    10. You should be able to export the spreadsheet without any problems/issues.

    At last but not least, try to open same site in different machine and different browser.


    Hemendra:Yesterday is just a memory,Tomorrow we may never see
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, August 06, 2013 4:39 AM
    Moderator
  • Hi,

    According to  your post, you got an error when you export your list to spreadsheet.

    Did you have been installed the Office Excel 2003 post-Service Pack3 hotfix package. If not, please install this hotfix to see if it will work.

    http://support.microsoft.com/kb/939269

    Or, you can try to the following methods, check whether it works,

    1.  Open the Internet Explorer

    2.  Tools

    3.  Internet Options

    4.  Advanced Settings

    5.  Scroll downwards and reach towards the section named as "Security"

    6.  CHECK FOR SERVER CERTIFICATE REVOCATION--which is by default checked

    7.  Unchecked it

    8.  Apply and Ok

    9.  Close all the internet explorers (IE) and open your SharePoint site in a new IE i.e. Browser/Explorer

    There are some similar posts you can refer to :

    http://social.technet.microsoft.com/Forums/en-US/dab0a5fc-f236-493a-ac75-2d71b6f0b946/cannot-open-an-excel-spreadsheet-from-a-sharepoint-site

    http://social.technet.microsoft.com/Forums/en-US/9e544f78-e8b6-46a5-b863-da0f596c9b58/cannot-connect-to-sharepoint-list-2010

    http://social.technet.microsoft.com/Forums/en-US/34bb6006-1ee5-4a44-8731-a2eae6b004db/excel-cannot-connect-to-sharepoint-list

    If you have any problems, please reply me.

    Thanks,

    Jason Guo

    Tuesday, August 06, 2013 4:57 AM
    Moderator

All replies