Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Sep 21 '11 at 7:46

This question came from our site for professional and enthusiast programmers.

    
I have similar setup ,works fine with https .But not sure if this could be the issue . I faced problem to open a video file in new browser.It asked for username and password.finally i embeded the video files in sharepoint. –  Nikhil May 1 at 3:43

2 Answers 2

Run IE as an Administrator and then try it. It should work or else try the following:

Resolution: (Work-around) 1) Log into the SharePoint site using forms authentication from office 2007 client 2) Open any existing excel document from the site. If you do not have an excel file on the server, upload an excel sheet to any of the document library. 3) It will be opened in browser. 4) Use Open in excel link on the page to open it in excel. 5) open it in read only or edit mode 6) Provide credential on the log- in popup 7) Now go to the SharePoint list and try exporting the list to excel option. It will work.

share|improve this answer

I also face the same problem.

The best way i suggest you to create extended application which will be AD Authenticated.

Below URL will be help you to creating the extended application.

How to Create or extend Web applications

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.