"The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser" in SharePoint 2010

This is very common excel issue in SharePoint, here is the reason for the this error.

Cause : If have 32 bit Microsoft office ( excel) installed on your machine and you are trying to browse the SharePoint and open the excel files in 64 bit Internet Explorer and you have 64 bit windows 7 installed, this error will occur.

Error: 

The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser:

• Data validation

Would you like to try and open this file in Excel?

Learn more about unsupported features

Internet Explorer 8	MS Office	OS	Supported
32 bit	32 bit	32 bit	YES
32 bit	32 bit	64 bit	YES
64 bit	32 bit	64 bit	NO
64 bit	32 bit	32 bit	NO
64 bit	64 bit	64 bit	YES

Solution:

 Use 32 bit IE when you have 64 bit OS and 32 bit Office installed. Hopes this helps.