Configure Maximum File Upload Size (Power Pivot for SharePoint)
Applies To: SQL Server 2016
Power Pivot workbooks often contain large amounts of data that result in files that exceed the maximum file size allowed for SharePoint uploads. When you try to upload a file that exceeds the upper limit, you will get the following error on SharePoint:
- "The specified file is larger than the maximum supported file size."
To increase the file size, start by adjusting the Maximum Workbook Size for Excel Services to 50 megabytes. This aligns the maximum file size limits for Excel to those of SharePoint web applications (set to 50 megabytes by default in SharePoint 2010 and 200 in SharePoint 2013). If your files exceed 50 megabytes in size, increase the file size limits for both Excel Services and your web application.
You must be a SharePoint administrator to change the maximum file upload size.
In Central Administration, in Application Management, click Manage service applications.
Click the name of your Excel Services Application.
Click Trusted File Locations.
Click the location to edit the properties. By default, Excel Services considers the default web application a trusted site. If you are using the default web application, click http:// to open the configuration page for this location.
Scroll to Workbook Properties.
In Maximum Workbook Size, increase the file size from 10 (the default value) to 50 or a larger size that accommodates the files you are working with.
By default, 50 megabytes is the maximum file upload size for SharePoint web applications. If you set Maximum Workbook Size to a number larger than 50 megabytes, follow the steps in the next procedure to increase the Maximum Upload Size for your SharePoint web application to the same value.
The maximum value that you can specify is 2 gigabytes (or 2047 megabytes as specified in Central Administration).
In Central Administration, in Application Management, click Manage web applications.
Perform the following steps only if you increased the Maximum Workbook Size in Excel Services.
Select the application (for example, SharePoint - 80).
On the Web Applications ribbon, click the down arrow on the General Settings button.
Click General Settings.
Scroll to Maximum Upload Size.
Set the property to the same number, or larger as the Maximum Workbook Size in Excel Services.