21 August, 2013

The workbook cannot be opened error while opening excel files in SharePoint 2010

I am using SharePoint 2010 and when users click on an .xlsx document in a document library it throws the following error message:

The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser:
• Data validation
• Sheet protection
Would you like to try and open this file in Excel?
Learn more about unsupported features

Number of things to check or troubleshooting steps to find out the culprit:
1.   Make sure that this file is not broken. Download a copy of this file and edit it Excel client. Remove the Consolidation, Data sources and Data validations on the file to have a test whether it fixes this issue.

2.   Check the event viewer and try to find out the exact error information as it will give you the account name where the problem lies.

3.   Check the SharePoint ULS logs where it will show the exact root cause.

4.   Check the supported and unsupported features: http://msdn.microsoft.com/en-us/library/ff595319%28v=office.14%29.aspx

5.   If you getting this error while trying to view the excel file in browser mode then please have a look on this article:

6.   If there are unsupported features then you need to remove it before uploading that excel file in SharePoint document library.

7.   You can define in the library settings whether or not to open documents in the browser or the client application. The default is set on the server, but you can overrule that at the library level. Since Excel Services cannot open workbooks with data validation, graphic object or VBA, many Excel files with basic functionality simply won't load in the browser.

8.   Make sure that you are using 32-bit version of IE- Microsoft Recommended. - This is very important as it resolves most of the issues.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Request: If you have any other resolution then please share so that it would be helpful for the entire community, Thanks again!

24 comments:

  1. without removing data validations can we view the workbook in xslx viewer

    ReplyDelete
    Replies
    1. Apoorva,
      You have asked a very valid question! No, it does not support 100% validation, that's why i mentioned in the first point (Remove the Consolidation, Data sources and Data validations on the file to have a test whether it fixes this issue). You need to remove completely and check the results. Once you are good that the results are fine then start with minor validation and then again check the results! - this will take some time to check the results as it's not 100% solid proof!

      Let me know in case of any further queries, Thank you!

      Delete
    2. I have doubt related to excel web access web part....Can we automatically reload the workbook in the EWA web part

      Delete
  2. Devops is not a Tool.Devops Is a Practice, Methodology, Culture or process used in an Organization or Company for fast collaboration, integration and communication between Development and Operational Teams. In order to increase, automate the speed of productivity and delivery with reliability.
    python training in bangalore
    aws training in bangalore
    artificial intelligence training in bangalore
    data science training in bangalore
    machine learning training in bangalore
    hadoop training in bangalore
    devops training in bangalore
    iot training in bangalore

    ReplyDelete
  3. Thanks for such a great article here. I was searching for something like this for quite a long time and at last I’ve found it on your blog. It was definitely interesting for me to read  about their market situation nowadays.

    Microsoft Azure online training
    Selenium online training
    Java online training
    Python online training
    uipath online training

    ReplyDelete
  4. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    AWS training in chennai

    ReplyDelete
  5. I would assume that we use more than the eyes to gauge a person's feelings. Mouth. Body language. Even voice. You could at least have given us a face in this test.
    Selenium training in bangalore

    ReplyDelete
  6. The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea. here by i also want to share this.
    AWS training in chennai

    ReplyDelete
  7. I am Here to Get Learn Good Stuff About AWS, Thanks For Sharing AWS.aws training in bangalore

    ReplyDelete
  8. This is really an awesome post, thanks for it. Keep adding more information to this.mulesoft training in bangalore

    ReplyDelete
  9. Really it was an awesome article,very interesting to read.You have provided an nice article,Thanks for sharing.salesforce developer training in bangalore

    ReplyDelete
  10. Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving.salesforce admin training in bangalore

    ReplyDelete
  11. Linking is very useful thing.you have really helped lots of people who visit blog and provide them use full information.servicenow training in bangalore

    ReplyDelete
  12. Your articles really impressed for me,because of all information so nice.cloud computing training in bangalore

    ReplyDelete
  13. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful .web designing training in bangalore

    ReplyDelete
  14. I think this is one of the most significant information for me. And i’m glad reading your article. Thanks for sharing!

    Bangalore Training Academy is a Best Institute of Salesforce Admin Training in Bangalore . We Offer Quality Salesforce Admin with 100% Placement Assistance on affordable training course fees in Bangalore. We also provide advanced classroom and lab facility.

    ReplyDelete
  15. Such a great word which you use in your article and article is amazing knowledge. Thank you for sharing it.

    Became An Expert In UiPath Course ! Learn from experienced Trainers and get the knowledge to crack a coding interview, @Softgen Infotech Located in BTM.

    ReplyDelete
  16. wonderful thanks for sharing an amazing idea. keep it...

    Softgen Infotech have the best Python Training in Bangalore . Any professional
    who is looking out to switch their career can enroll with us.

    ReplyDelete
  17. I am happy for sharing on this blog its awesome blog I really impressed. thanks for sharing. Great efforts.

    Looking for SAP HR HCM Training in Bangalore , learn from eTechno Soft Solutions SAP HR HCM Training on online training and classroom training. Join today!

    ReplyDelete
  18. I am happy for sharing on this blog its awesome blog I really impressed. thanks for sharing. Great efforts.

    Looking for SAP FICO Training in Bangalore , learn from eTechno Soft Solutions SAP HR HCM Training on online training and classroom training. Join today!

    ReplyDelete
  19. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    servicenow online training
    best servicenow online training
    top servicenow online training

    ReplyDelete

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.