Excel Services and Office Web Apps

Be aware that if you would like to use Excel Services for rendering your Excel files instead of using Office Web Apps, you would have to suppress the WOPI Binding that is responsible for viewing of Excel files. This is done through PowerShell in the SharePoint farm, it’s not a WAC setting.

New-SPWOPISuppressionSetting -extension XLSX -Action View

This command will suppress the WOPI Binding for the extension XLSX (Excel files) and for the WOPI ActionView.

It not necessary to iisreset on the SharePoint farm or even the Wopi farm or anything else.

But if you want to check if your files are rendered using WAC or Excel Calc you can take a look to the url showed.

If its viewed using Office Web Apps the URL will look something like this:
https://server/_layouts/15/WopiFrame.aspx/sourcedoc=/Documents/excel.xlsx
but if Excel Calc is rendering the document it should look like the following:
https://server/_layouts/15/xlviewer.aspx?id=/Documents/excel.xlsx

You can also check the WOPI suppression settings using the command Get-SPWOPISuppressionSetting

Finally, If you need to revert your changes, use the command Remove-SPWopiSupressionSetting

Update 2016/05/24: Additionally if any of this works, try to use the commando Remove-SPWopibinding -application “excel” this will remove all the Excel binding in the Wopi farm

Hope it helps!

Advertisements

3 thoughts on “Excel Services and Office Web Apps

  1. Would there be any way to locally override the use of Office Web Apps for Excel and force within the browser to use Excel Services?

    Even if I input a proper URL using xlviewer.aspx the file changes over to WopiFrame.aspx.

    Like

  2. Hey JLH! Try to use the command Remove-SPWopibinding -application “excel”, this will remove all the Excel binding in the Wopi farm, then there is no way to continue opening the links with Wopi farm instead of Excel Services

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s