28 | June | 2012 | Step Bi Step

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location – SharePoint 2010

Posted by Rajanihanth in Excel Services, SharePoint 2010 on June 28, 2012

One of my colleagues sent me an email saying that he is getting this error (see below) whenever he tried to open an excel workbook. I just clicked the same file in the same location and I am able to open it. 🙂

But when I click on the excel file drop down –> View in Browser then I also got the same error.

The text format of the error is:

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

To create an Excel Services Application trusted location, contact your system administrator.

According to the error message, obviously we need to add the document library path to Trusted File Locations in the Central Administration. So we will see the steps here.

Step 1: Go to Central Administration –> Manage service applications under Application Management

Step 2: Then click on the Excel Services Application

Step 3: Click on the Trusted File Locations

Step 4: Just click Add Trusted File Location under Excel Services Application

Step 5: Add the document library url (OR file location) on the Address box and check the Children trusted check box –> Click ok

Please note: Don’t use like http://server:1010/documentlibrary1/forms/default.aspx instead of http://server:1010/documentlibrary1

If you use SSL (Secure Sockets Layer)/HTTPS connections, just add https:// on the address.

If you want to read more about this just click here. The similar problem in SharePoint 2007 also, you can find the solution in my previous post.

After completing this configuration, you might get the “The workbook cannot be opened” error, if you want to get the solution just read here. 🙂

References:

1. http://sharepointknowledgebase.blogspot.ca/2011/12/excel-services-sharepoint-2010-trusted.html

2. http://technet.microsoft.com/en-us/library/ff191194.aspx

central administration, Children trusted, Excel Services, Excel Services Application, SharePoint 2010, Trusted File Locations, trusted location

3 Comments

System.NullReferenceException in Silverlight application designer in Visual Studio 2010

Posted by Rajanihanth in .Net, Silverlight on June 28, 2012

This is my Environment:

Windows 7 64 bit
VisualStudio 2010 with SilverLight 4 developer runtime

Problem: After upgrading the SilverLight 5 client, I tried to create a SilverLight Application and then I have got the following wired error message on the design tab 😦

The text format of the error is:

System.NullReferenceException
Object reference not set to an instance of an object.
at Microsoft.Windows.Design.Platform.SilverlightMetadataContext.SilverlightXamlExtensionImplementations.d__8.MoveNext()
at MS.Internal.Design.Metadata.ReflectionProjectNode.BuildSubsumption()
at MS.Internal.Design.Metadata.ReflectionProjectNode.SubsumingNamespace(Identifier identifier)
at MS.Internal.Design.Markup.XmlElement.BuildScope(PrefixScope parentScope, IParseContext context)
at MS.Internal.Design.Markup.XmlElement.ConvertToXaml(XamlElement parent, PrefixScope parentScope, IParseContext context, IMarkupSourceProvider provider)
at MS.Internal.Design.DocumentModel.DocumentTrees.Markup.XamlSourceDocument.FullParse(Boolean convertToXamlWithErrors)
at MS.Internal.Design.DocumentModel.DocumentTrees.Markup.XamlSourceDocument.get_RootItem()
at Microsoft.Windows.Design.DocumentModel.Trees.ModifiableDocumentTree.get_ModifiableRootItem()
at Microsoft.Windows.Design.DocumentModel.MarkupDocumentManagerBase.get_LoadState()
at MS.Internal.Host.PersistenceSubsystem.Load()
at MS.Internal.Host.Designer.Load()
at MS.Internal.Designer.VSDesigner.Load()
at MS.Internal.Designer.VSIsolatedDesigner.VSIsolatedView.Load()
at MS.Internal.Designer.VSIsolatedDesigner.VSIsolatedDesignerFactory.Load(IsolatedView view)
at MS.Internal.Host.Isolation.IsolatedDesigner.BootstrapProxy.LoadDesigner(IsolatedDesignerFactory factory, IsolatedView view)
at MS.Internal.Host.Isolation.IsolatedDesigner.BootstrapProxy.LoadDesigner(IsolatedDesignerFactory factory, IsolatedView view)
at MS.Internal.Host.Isolation.IsolatedDesigner.Load()
at MS.Internal.Designer.DesignerPane.LoadDesignerView()

Solution: The problem is the conflict of SilverLight versions and I have found the solution in this thread.

Step 1: Uninstall the latest SilverLight client which is SilverLight 5, the 1st one in the below control panel screen shot

Step 2: Uninstall SilverLight 4 developer, the next 1 in the above image

Step 3: Download and Install Microsoft Silverlight 4 Tools for Visual Studio 2010 (Add-on and pre-requisite files for Visual Studio 2010 to develop Silverlight 4 and RIA Services applications)