locked
Getting error while exporting to excel using the option "Actions" RRS feed

  • Question

  •   When I try and use the Export to Excel option(Actions -> Export -> Excel) that Sharepoint provides on an Access 2010 web database, I getting the error which i mentioned below.

    "The file you are trying to open is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"

    If I click Yes, I get a blank spreadsheet. If I export the report to excel directly from Access, it works fine.  But i want to export through Actions -> Export -> Excel.  Can this be corrected?

    Thursday, December 15, 2011 6:22 PM

Answers

  • Hi,

     

    Could you please share us your environment? What is the version of your SharePoint and Office. This forum is for pre-SharePoint 2010.

     

    You can try to export other lists to Excel to see if any error arise. If this issue is ubiquitous, you can try a repair.

     

    Hope this helps.

     

    Thanks.

     


    Pengyu Zhao

    TechNet Community Support

    • Marked as answer by Pengyu Zhao Monday, December 26, 2011 1:25 AM
    Thursday, December 22, 2011 8:26 AM