04 July, 2011

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

22 comments:

  1. Thank you, thank you.

    ReplyDelete
  2. repair Excel files after such errors as: Microsoft Excel unable to read file, This file is not in a recognizable format, EXCEL.exe has generated errors and will be closed by Windows. Program demonstrates a table with all data that it has recovered in its window. It works with *.xls, *,xlt, *.xlsx, xlsm, *.xltm, *.xltx, *.xlam formats of files.

    ReplyDelete
  3. This just helped me figure out an open issue on our environment. Thanks!

    ReplyDelete
  4. This helped me with a problem i was having. Thanks a lot.

    ReplyDelete
  5. I'd previously set the trusted location, but completely forget about the Maximum file size setting - thank you so much!

    ReplyDelete
  6. Perfect solution to a problem that cropped up as the Excel spreadsheet size grew.

    ReplyDelete
  7. Fabulous info! it works for me as well. Thanks Amol.

    ReplyDelete
  8. This article resolves my issue. Thank you.

    ReplyDelete
  9. Can you help me also.. I am failing to use my drop-downs on my excel file online.. (data validation..i think) plus i am getting the following warnings and errors when i open an excel file in my browser.

    1. Links DisabledLinks to external workbooks are not supported and have been disabled.
    2. Unsupported FeaturesThere are some features in your workbook that we can't show in the browser.

    Please help... Thanks

    ReplyDelete
    Replies
    1. are you using any links in your excel which points to external sources data?

      lets do thing-
      -download that excel sheet to your desktop
      -open it
      -copy the whole content
      -open a new blank excel
      -paste the content
      -save this new excel spreadsheet
      -upload it to SP
      -once uploaded ->click on the dropdown of that excel and select view in browser

      let me know the results, thanks

      Delete
  10. Thank you for your quick response. I have tried to copy the sheets to a new workbook - but it looses the formatting before i even upload it to SharePoint.

    Now the drop-downs at the top are showing but the ones that should pop up when i click in a cell are not.

    I have just realized also that.. when i open my excel in a browser the DATA and OPEN IN EXCEL options are not available.
    Could it be the reason why? If so.. how do i have them as options on web?

    Thank you so much..

    ReplyDelete
    Replies
    1. Ok, one thing has been cleared by this - Your farm excel functionality is working fine without any issues, the problem is with excel only, because if you open the blank excel via SP in browser mode then it will works like a charm :) now the issue remains formatting - this is a difficult part and you need handle this very carefully. I mean excel data will be same but external links/hyperlinks/linking to other docs - thats something usually causes the problem.

      also if you are using SP2010 then office 2010 is the recommended version and not like SP2010 and Office 2007.

      Best way / the bottom line is troubleshoot this problem step by step

      like-
      -create blank excel, copy the data from your existing excel
      -Upload to SP and check the browser functionality - working fine - move to next step
      -try some formatting (minor one), upload again and check the functionality

      I hope you got it what i meant to say- lets go by this way and i am pretty sure the issue will be resolved :)

      in case of any further queries then please feel free to reach out to me. Thanks again.

      Delete
  11. Dear Amol,

    Thank you very much for your assistance. I would like to know however why i don't have DATA and OPEN IN EXCEL on my tabs on excel web apps? I only have HOME, INSERT, and VIEW.

    How can i post a picture to you of what i mean?

    ReplyDelete
    Replies
    1. You can use this Knowledge forum to post the query with screenshot: http://sharepointknowledgebase.blogspot.com/p/blog-page_23.html

      Delete
  12. Additional Information: I am using SharePoint 2013 and Office 2010.

    Thanks :)

    ReplyDelete
    Replies
    1. Is there any machine which is having SP2013 and Office 2013 installed on the same machine?

      Delete
  13. Thanks for your reply,

    well, Sharepoint is installed on a separate server machine (running on windows server 2008 r2), Office Web Apps on another server (running on windows server 2008r2), Office 2010 is on my machine(client machine - runnning on windows 7) btw i dont have office 2013. i have office 2010.

    ReplyDelete
    Replies
    1. Ok, no worries. Did you follow the previously suggested action plan? whats the output? did that work?

      Delete
  14. Thanks Amol. Your site is very helpful and to the point.

    Thankkkkkk you.. Most of my problems have been answered here!! Keep on the good work.

    ReplyDelete
    Replies
    1. Awesome :) Thanks for the confirmation! My pleasure as the mentioned information helped you to resolved your issue and you got the insight that you were looking for. Thanks again...

      Delete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.