Trying to export office 365 SharePoint site list to excel 2016. following error occurs."An unexpected error has occurred. Changes to your data cannot be saved"

Any suggestions or solutions are appreciated.

  • How are you doing the exporting? If you are using browser, are you using IE? – moe Nov 1 '16 at 5:42
  • yes I am using IE 11 – vin Nov 1 '16 at 6:15
  • Check your list's column names that they don't have any special characters (%, &, ...). Also reportedly people have had problems with spaces in the column names ("Column name" vs. "Column_name"). – moe Nov 1 '16 at 6:19
  • Do I have to change for example even (Created By to Created_By) – vin Nov 1 '16 at 6:24
  • Just at first eliminate any special characters and test the behavior. I haven't experienced any issues with lists having the default "Created By"-column as it is, so that more likely concerns your custom columns. – moe Nov 1 '16 at 6:28

I've had this issue with SharePoint 2010 and Excel 2016 and I had to uninstall the 32-bit version of Office 2016, reboot, the install 64-bit version. It should then work. Hope this helps.


I have the same problem. There are no special characters. Here is the kicker. If I export the query file ONLY from Edge Dev and ONLY From Edge dev it works


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.