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