Saturday, August 10, 2013

Maximum Excel Workbook size when using Office Web Apps 2013

When trying to open a workbook in the browser I got the following error message:


By default, Office Web Apps maximum Excel workbook size = 10 MB

imageTo change the value, you will have to use the following command and define a custom new value for the maximum excel workbook size;


You will have to do an IISRESET on all SP servers to make this change effective

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 on a per SharePoint farm basis, it’s not a WAC setting.

PS C:\Users\adm_jgremmen> New-SPWOPISuppressionSetting -extension XLSX -Action View

This command will suppress the WOPI Binding for the extension XLSX (Excel files) and for the WOPI Action View. If we now have Excel Services running in our SharePoint farm then Excel Services will be responsible for viewing Excel (XLSX) files. But Office Web Apps 2013 will be responsible for previews (in search and document libraries) and editing of the files.

You don’t have to do anything else, no IISRESET (this must be the only time you don’t need this for a SharePoint config change!) or anything else.


Verify if Excel files are rendered by Office Web Apps

If you are unsure if Excel files are rendered using WAC or Excel Calc you can easily take a look at the URL. When Office Web Apps is responsible for the rendering the URL will look something like this:
And when Excel Calc is rendering the document it should look like the following:

You can also check the WOPI suppression settings using the Get-SPWOPISuppressionSetting cmdlet if you have shell access to the SharePoint farm.



How to switch back to Office Web Apps rendering the Excel files

Of course you can revert back to using the Office Web Apps for rendering of the Excel files. This is done using the Remove-SPWOPISuppressionSetting cmdlet

No comments:

Post a Comment