Can't open excel doc with excel services in Sharepoint 2010

Posted on 2011-05-12
Last Modified: 2012-05-11
The is one spreadsheet on our SHarepoint 2010 site which does not open with Excel services. It shows the attached error and after clicking yes, opens with normal Excel. It's not end end of the world, but is really annoying after a few months.  Excel Services
Question by:Mayogroup
    LVL 31

    Expert Comment

    by:Jamie McAllister MVP
    Sheet protection is not supported so you need to remove it.

    End of this article tells you how to remove it;

    After that you should be set.

    Author Comment

    Sheet protecting is not enabled on the Spreadsheet. So not sure why this error occurs.
    LVL 31

    Accepted Solution

    Difficult for me to say from here of course. I'd check that there aren't any workbooks or tabs you are missing in this sheet. I tend to trust these error messages.

    Otherwise, re-create the sheet. Unless SharePoint likes this it won't play ball. There's no switch to flick in SharePoint that will get rid of this.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now