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

When I open a sharepoint Excel file, the error message is: The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser.

I know this is a normal function of sharepoint, but is there any way make sharepoint not show this message? Thanks in advance.

share|improve this question
    
does it show the message and let you view teh workbook or does it not let you view it atall? –  ali Sharepoint Aug 20 '12 at 16:01
add comment

4 Answers

You can force opening a file with the client application, just modify the advanced library settings:

At the section "Open documents in Browser" select "Open with client application"

share|improve this answer
add comment

As you know Office Web Apps doesn't support this feature "Data validation”.

For you to open the file you can do two things: either open it in Excel 2010 directly, or you can open it in Outlook Web Access (OWA) if you remove the data validation but you would need to open the file in excel first!

I dont think you can stop the error message from appearing. I could be wrong but I would think you couldnt stop the error message from appearing.

share|improve this answer
add comment

Try it out in IE7 or above. Some times it matters which version of IE we are using to view office documents in SharePoint. Same problem may repeat in older IE versions also...

share|improve this answer
add comment

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.