Increasing the Maximum Size of Excel Sheets for SharePoint
Getting data from an Excel worksheet that exceeds the maximum allowable size in SharePoint, results in a "413 Request Entity Too Large" message.
To avoid the message, you must increase the size of workbook allowed to be opened by Excel Services ands the default IIS request size.
To increase the size of a workbook in Excel Services
1. Open SharePoint Central Administration.
2. Navigate to Application Management > Manage Service Applications > ExcelServiceApp > Trusted File Locations.
3. Select the appropriate Address.
4. Under the Workbook Properties section, locate a Maximum Workbook Size option.
5. Set this value to the required file size in MB.
6. Click OK to save the setting.
To avoid error messages, make sure the value is higher than the largest workbook size in SharePoint.
To increase the default IIS request size
1. Open a command window.
2. Navigate to
<drive>\Windows\System32\inetsrv
3. Type the following command:
appcmd.exe set config "http://localhost/<rmft_virtual_dir>" -section:system.webServer/serverRuntime /uploadReadAheadSize:"request size in bytes" /commit:apphost
For example:
appcmd.exe set config "http://localhost/repliweb-mft"-section:system.webServer/serverRuntime /uploadReadAheadSize:"100000000" /commit:apphost
4. You can check the configuration using the following URL in your browser:
https://<your site>.com/_vti_bin/ExcelRest.aspx/<document library>/<folder (optional)>/<file name>.xlsx/OData/<sheet name>