The "Export to Excel" function of SharePoint list work incorrectly. We got the error message as below. The Office version of PC is Office 2007 with the build number as image below. Please help support.

Hi,

Whether you use claim based authentication with SharePoint 2010, if it is, when you use export to excel functionality on any SharePoint list, it works fine with Office (Excel) 2010 client but with Office (Excel) 2007 client.

Office 2007 does not support FBA/Claim based authentication and directly tries to log-in using your windows credentials.

Here are similar issues and solutions, you can use as a reference:

http://www.techques.com/question/19-19829/SharePoint-2010-Export-to-Excel-Fails-Claims-Based-Authentication

https://joshihemant.wordpress.com/2011/06/24/error-you-do-not-have-adequate-permissions-to-modify-this-list-changes-to-you-data-cannot-be-saved/

Best Regards,

Lisa Chen

Forum Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.