Export to Excel from Sharepoint giving error "An unexpected error has occurred. Changes to your data cannot be saved."

Question

Hi guys,

I tried to export to Excel from a Sharepoint view as follows.

1. In Sharepoint, click on Export to Excel.
2. Save & open query.iqy in Excel.
3. The Sign In windows appeared. 

4. Sign in with my Office365 account.
5. The error "An unexpected error has occurred. Changes to your data cannot be saved." appears.

I found the error in Event Log too.

An unexpected error has occurred. Changes to your data cannot be saved.

P1: 101387

P2: 16.0.12430.20288

P3: 

P4: 

I deleted the accounts in Windows Credentials and Access work or school, and tried the below link but it doesn't work.

https://answers.microsoft.com/en-us/msoffice/forum/all/office365-sharepoint-list-export-to-excel/8a86f9bf-379b-48ca-a5cf-b4026618c64f

Please advise me on this.

Thanks a lot!

Answer 1

Hi Dihao,

Thanks for the information.

Signing out for Office apps and removing credentials didn't help.

I haven't tried to increase the timeout in registry.

After I reset Windows User profile and reinstalled Office, it got fixed.

Best regards,

Hung

Answer 2

Hi Hung_hk，

From your description, when you open a SharePoint view in your Excel application, you would receive an error message in your screenshot. It seems that you have tried to reverify your account credential in Excel application by signing out from Office application and remove the credentials from Credential manager.

Based on the error message, the error might be caused due to the timeout of Excel application when it is fetching data from SharePoint Online. Try to use registry key to increase the default Excel timeout value to 90000, or in milliseconds.

You can follow the steps in this article about Unable to export to Excel from SharePoint Online to  add the registry key in Registry Editor.

In addition, if the problem still exists after you tried out the above methods, may I know the following information.

1: Your Office application version. From your log, it seems that you are using Office 365 version 2001 Build (12430.20288) Monthly Channel. If it is convenient, you can go to File >Account >Under Product Information to share a screenshot with us here.

Notes*: To protect your information, please remove any private information before you share the screenshots with us. Thank you.*

2: Does this error occur when you open a SharePoint view in another SharePoint list or SharePoint site, or it happened to this SharePoint list only? You can switch to a different SharePoint site and see whether the same error happens.

3: Did your colleagues in your organization have the same error?

4: When did this error happen? Did you make any changes to your PC before it occurred, such as update Office application?

Best regards,

Dihao

Answer 3

Hi Hung_hk， 

Have you checked my reply above? If there are any updates, please feel free to post back here and share the above information with us at your convenience.

Best regards,

Dihao

Answer 4

Hi Hung,

Thank you for your updates and sharing your solution with us here. It seems that the error is related to your user profile or Office client. Glad to hear that the problem is fixed at the end. I would like to make a summary below which I believe it can help the other users who may face the same scenario in the future.  Appreciate your sharing again.

Issue Symptom:

=================

Export SharePoint list data to Excel giving an error about "An unexpected error has occurred. Changes to your data cannot be saved."

Issue Environment:

================

Excel desktop application/Windows 10

Solution:

===============

• Reset Windows User Profile or create a new Windows User Profile.

Some useful resources:

Fix a corrupted user profile in Windows

Create a local user or administrator account in Windows 10

• Reinstall Office application.

Uninstall Office from a PC (Suggest a completely uninstall Office with the uninstall support tool)

Reinstall Office 365

Best regards,

Dihao