We know that excel files with macros and password protections are not supported to view in Browser using Office Web App / Excel Web App. In this SharePoint shows small dialogue where it has 'Open In Excel' option. However, in our case for some documents this option is grayed out and for some of them its working as expected (Open In Excel option not grayed out). Please find following screenshot. 'Open In EXcel' button is grayed out.
Is there any limitations on Office Web Apps / Excel web app that we can only x number of macros / password protected sheet or x number of rows of data with password / macros? What is the best way to enable the Open in Excel option for this scenario on Excel Office Web App / Office Web Apps integrated with SharePoint 2013 environment?