PowerPivot in SharePoint 2016 Workbooks are too large
-
not 2013 not 2010. 2016! PowerPivot data refresh works fine with workbooks under 10mb but not larger than that. Where the elephant in Central Admin do I increase the size of the workbook in SharePoint 2016. I did mention this is 2016 On Premise and Not 2013. Thoughts
To err is human to really mess up you need a computer
-
not 2013 not 2010. 2016! PowerPivot data refresh works fine with workbooks under 10mb but not larger than that. Where the elephant in Central Admin do I increase the size of the workbook in SharePoint 2016. I did mention this is 2016 On Premise and Not 2013. Thoughts
To err is human to really mess up you need a computer
yep, solved it myself.
Solved it finally.
On the OOS server. in PowerShell run the following commands. Change 25 to whatever you want.
$farm = Get-OfficeWebAppsFarm
$farm.ExcelWorkbookSizeMax = 25
Set-OfficeWebAppsFarm -ExcelWorkbookSizeMax 25
restart-service wacsm
$farm.ExcelWorkbookSizeMaxTo err is human to really mess up you need a computer