Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Excel Error :: This workbook cannot be opened..

Posted by Paul on December 28, 2014


While working with Excel Services we might often get an error shown below:

This workbook cannot be opened because it is not stored in a trusted location.

image

Problem

The location of excel file (library) may not be a trusted file location.  You can have to add the library location to the Trusted File Locations through SharePoint Central Administration.

 Solution

Central Administration > Service Applications > Excel Service Application > Trusted File Locations for this.

image

Create a new item with http:// as the string.

image

Check the Children Trusted label and Save the item.  Your new item will look like  below.

image

References

http://technet.microsoft.com/en-us/library/jj219698%28v=office.15%29.aspx

Summary

In this post we have explored a common Excel Services error scenario & solution.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s