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 '17 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. – Steve G Jan 20 '17 at 8:41

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, privacy policy and cookie policy

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