sharepoint project management

Excel Error “An Unexpected Error has Occurred” when Exporting Report

January 3, 2018 by

A particular client had an issue exporting a report to Excel and got the following Excel error:


“An Unexpected error has occurred”



The following error message appearing during the loading of the file in Excel.



This is a generic SharePoint issue and can be resolved directly in Excel.

Excel Error Resolution:

For Microsoft Excel 2010 onwards:

  1. Open Microsoft Excel.
  2. Click File and then click Options.
  3. In Excel Options, click Advanced.
  4. Scroll down to General. Uncheck the box for ‘Ignore other applications that use Dynamic Data Exchange (DDE)’.

    DDE Excel Error
  5. Click OK


This should resolve the issue. If you are still experiencing problems with opening the file in Excel, please reach out to


I hope this helps!


Image credit 

Jonathan Browne
Latest posts by Jonathan Browne (see all)