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

I just came across one of my clients excel issue. When she is trying to open excel file by clicking on it, getting "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location" error. This generally happens if given site is not added as a trusted site in SharePoint central administration. Please go to the central administrations and do the steps mentioned below:

1. Open Central Web Administration
2. Click on Manage Service Applications
3. Click on Excel services Application.
4. Click on “Trusted file locations”
5. Add Trusted file
1. Address textbox write http://
2. Check Children trusted box under Trust Children
3. Check User-defined functions allowed under Allow User-Defined Functions
6. Repeat step 5 with address as https://(I would like to mention here that all their sites are secured(https))

Above steps resolved my issue successfully. Please post queries or comments, if any.

Change content type hub url on managed metadata service

Hi Friends,

Just come across a requirement of changing content type hub(CTH) url in managed metadata service(MMS). Initially we created a site collection and assigned it as a CTH site. Recently while working on some other stuff, one of the developer deleted the existing site.!!!! Big issue!!!

At the first glance we thought it must be a big issue but i wrote below powershell script to change my new site collection as CTH:


Set-SPMetadataServiceApplication -Identity "MyManagedMetadataService" -HubURI "http://spport01:5555/site/cth/"

Hurdle? I can be resolved!!!!


Post me for your responses and queries.

Create web application and site collection using powershell

Hi Folks,

Just came across a requirement of creating web application and site collections using power shell, posting it here.

Open an empty notepad file and copy paste below code segment :

Add-PsSnapin Microsoft.SharePoint.PowerShell

#My Parameters

$WebAppName = "MyWebApplication"
$WebAppHostHeader = "http://MyWebHost"
$WebAppPort = 7575
$WebAppAppPool = "AppPool_7575"

# This User has to be a Sharepoint Manager Account
$WebAppAppPoolAccount = "MyDomain\hirwani"

$WebAppDatabaseName = "WSS_Content_7575"
$WebAppDatabaseServer = "MySQLServer\SharePoint"
$template = Get-SPWebTemplate "STS#0"


# Create a new Sharepoint WebApplication

New-SPWebApplication -Name $WebAppName -Port $WebAppPort -HostHeader $WebAppHostHeader -URL ("http://" + $WebAppHostHeader) -ApplicationPool $WebAppAppPool -ApplicationPoolAccount ($WebAppAppPoolAccount) -DatabaseName $WebAppDatabaseName -DatabaseServer $WebAppDatabaseServer

# Create a new Sharepoint Site Collection

New-SPSite -Name "Root" -Url "http://in-mum-tfsport1:7575/" -Template $template -OwnerAlias "MyDomain\hirwani"

Save this notepad with .ps1 extension. Now execute it, you should get a new web application and site collection created.

Note : Change above parameters as per your requirement. Post here if you have any questions/suggestions.

Adding and activating solution in solution gallery

Fea days back, i came across this requirement to add solution to site solution gallery. I wrote below code segment :

ClientContext context = new ClientContext("http://in-air-eyshr2:1234/sites/ETD02");

//Activate Publishing feature
//Add wsp from file system to SP solution gallary
Folder destionationFolder = context.Web.GetFolderByServerRelativeUrl("_catalogs/solutions");
FileCreationInformation fci = new FileCreationInformation();
fci.Content = System.IO.File.ReadAllBytes("D:/WSPS/LDTest.wsp");
fci.Url = "LDTest.wsp";
fci.Overwrite = true;
Microsoft.SharePoint.Client.File fileToUpload = destionationFolder.Files.Add(fci);
context.Load(fileToUpload);
context.ExecuteQuery();

//Activate solution
DesignPackageInfo info = new DesignPackageInfo()
{
  PackageGuid = Guid.Empty,
  MajorVersion = 1,
  MinorVersion = 1,
  PackageName = "LDTest"
  };
  Console.WriteLine("Installing design package ");
  //Relative Path of Solution Uploaded in Solution Gallery
  //string fileRelativePath = "D:/WSPS/testwsp.wsp";
string fileRelativePath = "/sites/ETD02/_catalogs/solutions/LDTest.wsp";
DesignPackage.Install(context, context.Site, info, fileRelativePath);
context.ExecuteQuery();
Console.WriteLine("Applying Design Package!");
DesignPackage.Apply(context, context.Site, info);
context.ExecuteQuery();

and it gave me following output:

You can give me your suggestions or post relevant questions, if any

Learning SharePoint 2013

As SharePoint 2013 hits the floor, let's start learning it as soon as possible. To start with we need to learn it's basic structure.

It's based on .Net framework 4.5. The major changes are in the development area where Microsoft has launched App model which i am going to discuss more in my coming posts. Basic look & feel will be as below:

If we go to Site Settings:

Other major enhancements are 


Continuous Crawl: There has been a major upgrade to the crawling and indexing components in SharePoint Search. Now each and every document would be available to user instantly.

Cross-site Publishing: Cross-site publishing lets you store and maintain content in one or more authoring site collections, and display this content in one or more publishing site collections. When you change the content in an authoring site collection, those changes are now displayed on all site collections that are reusing this content.This feature helps ensure content is consistent when shared across several different areas and sites. 

SkyDrive: Users can now share documents and files from a personal SkyDrive or keep them secured for their personal use. SkyDrive files can still be indexed and located through search if they have been shared to that user.

Add Entries in Web.Config File in SharePoint 2010

It may depend on core client requirment to modify the configuration files. I came across such requirment and below is the way to modify your configuration file. Remember one thing, before doing this activity first you take a backup of your configuration file.

First add SharePoint administration namespace using below segment:
using Microsoft.Sharepoint.Administration;

Now you can write below code segment on a button's click event.

SPWebService service = SPWebService.ContentService;

SPWebConfigModification myModification = new SPWebConfigModification();
myModification.Path = "configuration/SharePoint/SafeControls";
myModification.Name = "SafeControl[@Assembly='MyCustomAssembly'][@Namespace='MyCustomNamespace'][@TypeName='*'][@Safe='True']";
myModification.Sequence = 0;
myModification.Owner = "User Name";//In my case i used System account
myModification.Type = SPWebConfigModification.SPWebConfigModificationType.EnsureChildNode;
myModification.Value = "<SafeControl Assembly='MyCustomAssembly' Namespace='MyCustomNamespace' TypeName='*' Safe='True' />";
service.WebConfigModifications.Add(myModification);

service.Update();
service.ApplyWebConfigModifications();

Content Query not visible in SharePoint 2010

Content Query is a needful webpart in Sharepoint as it relates with user very smoothely.If you are not able to see this webpart in your gallary under Content, then turn on "SharePoint Server Publishing Infrastructure" in your top level site collection administration.After this step, turn on "SharePoint Server Publishing" feature in your affected site.

NOTE: No need to go to central admin for this solution.

If you are getting any error while doing any of the above activity(as i was) then lets open PoweShell(CMD) and try below stsadm commands and will do you work:

(to activate top level site collection feature)
stsadm -o activatefeature -name publishingResources -url "SiteCollectionURL" -force

(to activate publishing feature in affected site)
stsadm -o activatefeature -name PublishingWeb -url "Affected Site URL" -force

Hope this will work.

All the best