SharePoint 2013 - Trusted file location Error

As working in the support industry, we use to get lot of tickets on daily basis so out of that we get one ticket today which was based on excel web part error-

You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file.

From the above error message, it seems very clear to the SharePoint Administrators/IT experts who are handling the SharePoint environments/providing support to the SharePoint Infrastructure.

Let me explain the resolution step by step so that they would be no confusion but still in case of any queries/questions then please feel free to contact me so that I can resolve your issue / guide you in appropriate directions.  Thank you.

Resolution:-

1.       Open the SharePoint 2013 central administration

2.       Application management

3.       Manage service applications

4.       Excel services service application

5.       Click on it

6.       It will open ‘manage excel services application page’

7.       Click on trusted file locations

8.       Add trusted file location

9.       Inside the Address filed, enter the document library URL where the excel documents are stored

10.   Select children trusted

11.   Keep all the other values as it if you don’t have any specific requirements

12.   Click OK

That’s it- You are done! – Go back to your page where the excel web access webpart was throwing the error, refresh the page and check the results!

Thank you.  Happy SharePoint to all of you

create site + delete site - SharePoint 2013

Site collection is a very important part by which you actually started building the whole house. Creation of list, libraries, record center, management, usage analysis, reports & so many things- bottom line is you need a site collection. When you create a site collection then its requirement proper management also which involves permissions part (not going to discuss in this article but FYI) so let’s start!

In this article, we will concentrate on site collection guidelines:

·         Site creation by GUI as well as by PowerShell

·         Site Deletion by GUI as well as by PowerShell

Site collection will already be created underneath the web application and there can be so many site collections present in a single web app. So site collections can be created by two ways-

1)       GUI i.e. Central Administration

2)       Command prompt i.e. PowerShell

Let’s try to understand step by step each section in detail-

Create site collection by using – Central Administration

1)       SharePoint 2013 Central Administration

2)       Application management

3)       Create site collections

4)       Select the appropriate web application from the top dropdown underneath you want to create the site collection

5)       Provide title, description ,URL and template selection as per your requirements

6)       Provide the names for primary and secondary site admins as per your requirements

7)       Apply appropriate quota

8)       Click OK

9)       Site collection will be created.

10)   That’s it- you are done!

Create site collection by using – PowerShell

New-SPSite -Url "<URL for the new site collection>" -OwnerAlias "<domain\user>" -Template $template

As we have understood the creation part, let’s try to understand the site deletion part by using the same ways-

1.       Site deletion by Central Administration.

2.       Site deletion by PowerShell.

Site Deletion by using – Central Administration

1.       SharePoint 2013 Central Administration

2.       Application management

3.       Delete site collections

4.       Select the appropriate web application from the top dropdown underneath you want to delete the site collection

5.       Select the appropriate site collection

6.       Click OK

7.       Read the warning

8.       On the delete site page

9.       Click on Delete

Site deletion by using PowerShell

Remove-SPSite -Identity "<URL>" –GradualDelete

Where-

·         URL stands- URL of the site collection

·         Gradualdelete-reduces the load on the system.

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.