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.
9
-
How are you doing the exporting? If you are using browser, are you using IE?– moeCommented Nov 1, 2016 at 5:42
-
yes I am using IE 11– vinCommented Nov 1, 2016 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").– moeCommented Nov 1, 2016 at 6:19
-
Do I have to change for example even (Created By to Created_By)– vinCommented Nov 1, 2016 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.– moeCommented Nov 1, 2016 at 6:28
|
Show 4 more comments
2 Answers
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