Export to Excel from a SharePoint 2010 list was previously working fine, but since October/November last year this has stopped working, with the error message 'An unexpected error has occurred. Changes to your data cannot be saved."

If anyone has any ideas to get this working again I'd appreciate it. It may be an office update that has caused this, but I haven't been able to find out which file as yet.

  • Is the site listed in your Trusted Sites zone in IE? Not having it always seems to break this functionality for us.
    – jpollar
    Jan 13, 2017 at 21:54
  • Yes, that's one of the first things I checked. That and Compatibility View. I was wondering if this was as a result of a KB update because it was working before the year end.
    – NightM0de
    Jan 20, 2017 at 8:41

1 Answer 1


I've found the answer to this. You need to change the default install of MS Office from 32-bit to 64-bit. Once 32-bit has been removed, reboot, then install 64-bit version it should work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.