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

Jonathan Browne
By | Updated January 3, 2018 | 1 min read
sharepoint project management

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 support@brightwork.com.


I hope this helps!


Image credit 

Jonathan Browne
Jonathan Browne

Don't forget to share this post!