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”

xml

 

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

xml2

 

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
Latest posts by Jonathan Browne (see all)