Hi,

I have Excel file configured with OLAP cube. I have created the Excel service application, with trusted file location on my SP site.

I have uploaded this excel into this location. However the View In Browser and Edit in Browser options are not available for this Excel. However if I uploaded a simple excel then View in Browser option is available.

Please let me know how to enable the View in Browser or Edit in Browser options for Excel with OLAP Data.

Hi Abhijit,

For enabling "Edit in Browser" option, you need to install and configure Office Web App for your SharePoint farm.

More information, please refer to:

https://social.technet.microsoft.com/Forums/office/en-US/c8d75cc1-939a-4d1b-9e7e-a55749fa61c1/no-option-to-edit-in-browser-with-excel-file-in-sharepoint-library?forum=sharepointadmin

Please try to click the Name of the Excel file with OLAP, check if this excel file could be viewed in browser.

Best Regards,

Wendy

HI Abhijit,BY default with the configuration of Excel services view in browser and edit in browser will not be possible.To achieve that feature,you need to configure your farm with OWA.Please check the links below that explains more in details.

http://expertsharepoint.blogspot.my/2014/09/view-in-browser-does-not-work-only-for.html