Excel Services cannot load the workbook that you requested.

When I am trying to Publish an excel to SharePoint using excel services I am getting the error message

File Not Found

Excel Services cannot load the workbook that you requested.

Usually if the file contains something that can't be published through excel services you would get a different error.

Generally the excel error messages highlights something so that we can take appropriate actions but the above message does not indicate anything. If you have a excel file which consist of 158 Tabs and the size present in MB's (Size of my excel file:11MB) so it is very difficult to find out which tab is causing the problem.

I did some testing and found out that this issue occurs because of large file size.

Troubleshooting carried out in the following manner:

Original File size: 11.0 MB         Result: Not Working

File Size: 8.92MB                        Result: Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-8.92MB.xlsx 

File Size: 9.22MB                        Result: Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-9.22MB.xlsx 

File Size: 9.45MB                        Result: Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-9.45MB.xlsx 

File Size: 9.94 MB                       Result: Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-9.94MB.xlsx 

File Size: 10.01MB                       Result: Not Working

https://SharePoint2007/personal/amol/Shared%20Documents/Metrics%20Replica-10.01MB.xlsx 

By default, Excel Services allows loading a file whose size <= 10MB on the server. 

When you add a QT with >= 3500 records, the file size grows > 10 MB and following alert appears: "Excel Services cannot load the workbook that you requested." when you try to load that on the server.

Resolution:

Go to Central Admin Page 

Select the SSP link/Shared Service Provider

Click on Trusted File Locations

Select the trusted location where your site is, and set Maximum Workbook Size = 100 MB (also set "session time out" and "Maximum request duration" = 3000 or more to make sure that server has enough time to process the workbook during load and before time outs).

If you have any queries/questions regarding the above mentioned information then please let me know...

I would be more than HAPPY 2 HELP U as well as RESOLVES UR ISSUES, Thanks