We have a 2010 SharePoint implementation and the clients are using Office 2007 SP2 and IE 8. Security is handled using claims-based authentication over http. In Office 2010 we are able to go to a list and export to excel. We get prompted for credentials again but the after that all is good.
Using Excel 2007 on the client results in the following error:
You do not have adequate permissions to modify the list. Changes to your data cannot be saved.
From what I have read this is because Office 2007 doesn't support claims based authentication.
Is there a solution to this problem?