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.
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
Thank you, thank you.
ReplyDeleterepair 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.
ReplyDeleteThis just helped me figure out an open issue on our environment. Thanks!
ReplyDeleteGreat thanks
ReplyDeleteThis helped me with a problem i was having. Thanks a lot.
ReplyDeleteI'd previously set the trusted location, but completely forget about the Maximum file size setting - thank you so much!
ReplyDeletePerfect solution to a problem that cropped up as the Excel spreadsheet size grew.
ReplyDeleteThank you!
DeleteFabulous info! it works for me as well. Thanks Amol.
ReplyDeleteThis article resolves my issue. Thank you.
ReplyDeleteCan 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.
ReplyDelete1. 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
are you using any links in your excel which points to external sources data?
Deletelets 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
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.
ReplyDeleteNow 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..
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.
Deletealso 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.
Dear Amol,
ReplyDeleteThank 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?
You can use this Knowledge forum to post the query with screenshot: http://sharepointknowledgebase.blogspot.com/p/blog-page_23.html
DeleteAdditional Information: I am using SharePoint 2013 and Office 2010.
ReplyDeleteThanks :)
Is there any machine which is having SP2013 and Office 2013 installed on the same machine?
DeleteThanks for your reply,
ReplyDeletewell, 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.
Ok, no worries. Did you follow the previously suggested action plan? whats the output? did that work?
DeleteThanks Amol. Your site is very helpful and to the point.
ReplyDeleteThankkkkkk you.. Most of my problems have been answered here!! Keep on the good work.
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