رفع خطای excell

Then tried opening the file in the browser again only to be confronted with a new error "The workbook cannot be opened." This had me scratching my head for a little while until I looked in the event log where I found that the Service Account being used for Excel Services hadn't been given any rights on the content database. After which the fix was easy to implement with the following PowerShell commands

view plaincopy to clipboardprint?

1. $webApp = Get-SPWebApplication "http://YourSharePointSite"
3. $webApp.GrantAccessToProcessIdentity("YourDomain\ExcelServicesAccountName")

$webApp = Get-SPWebApplication "http://YourSharePointSite" 

$webApp.GrantAccessToProcessIdentity("YourDomain\ExcelServicesAccountName")

Hopefully this will save someone else a bit of time.

رفع خطای power pivot

 

 

 

Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’. This is not what you were planning on seeing, am I correct? Didn’t think so. How do we fix this and why is it happening?

Why it happens: This particular library type needs an ASP.Net control which can’t be found because the code for it is in a dll that is missing. It is likely occurring because powerpivotwebapp.wsp has not been deployed to the particular Web Application where the site in question is located.

How to fix it: Luckily the fix isn’t too difficult, although it does require that you are an administrator since we need to do some work in Central Administration. See below for the steps.

1. Open SharePoint 2010 Central Administration from the Start Menu or by typing in the web address in your browser
2. Go to the System Settings section
3. Click on Manage Farm Solutions under the Farm Management section
4. Click on powerpivotwebapp.wsp
5. In the Deployed To section the web application where the error occurred will not be listed
6. Click Deploy Solution at the top of the screen (Shown in the first screenshot below)
7. In the Deploy To section select your web application from the drop down list (Examples in second screenshot below)
8. You have the option to schedule the deployment, keep the Now button selected if you want to be able to use the gallery immediately
9. Click OK
10. Go back to your site and click on the link to load the PowerPivot gallery again, don’t just refresh the error page

Image 1: On this screen click Deploy Solution in the top left corner.

Image 2: Select your web application from the drop down list and click OK.

خطای power pivot

After installing PowerPivot for SharePoint 2010 for the first time, I added a PowerPivot Gallery to one of my existing sites and I was presented with the following error message:

“The referenced file ‘/_layouts/PowerPivot/ReportGalleryView.ascx’ is not allowed on this page.”

After doing some research, I found this blog post. For whatever reason, Microsoft missed a step for the feature activation of the PowerPivot controls that adds the controls to the Safe Controls in the Web.Config file of your web application. You have to do this manually. For each Web.Config file on each server for each web application, you have to add the following Safe Control:

SafeControl Src="~/_layouts/powerpivot/*" IncludeSubFolders="True" Safe="True" AllowRemoteDesigner="True" <"SafeAgainstScript="True

After adding that to your Safe Controls in each web.config, do an IISRESET and you are all set.

 

http://www.sharepointjohn.com/sharepoint-2010-powerpivot-the-referenced-file-is-not-allowed-on-this-page/

خطای power pivot

After installing PowerPivot for SharePoint 2010 for the first time, I added a PowerPivot Gallery to one of my existing sites and I was presented with the following error message:

“The referenced file ‘/_layouts/PowerPivot/ReportGalleryView.ascx’ is not allowed on this page.”

After doing some research, I found this blog post. For whatever reason, Microsoft missed a step for the feature activation of the PowerPivot controls that adds the controls to the Safe Controls in the Web.Config file of your web application. You have to do this manually. For each Web.Config file on each server for each web application, you have to add the following Safe Control:

SafeControl Src="~/_layouts/powerpivot/*" IncludeSubFolders="True" Safe="True" AllowRemoteDesigner="True" <"SafeAgainstScript="True

After adding that to your Safe Controls in each web.config, do an IISRESET and you are all set.

 

http://www.sharepointjohn.com/sharepoint-2010-powerpivot-the-referenced-file-is-not-allowed-on-this-page/

فرم رندر نمی شود. دلیل آن ممکن است پیکربندی نآدرست سرویس Microsoft SharePoint Server State باشد. برا

راه حل:

To configure the State Service by using the Farm Configuration Wizard

1) On the Central Administration Web site, click Configuration Wizards.

2) On the Configuration Wizards page, click Launch the Farm Configuration Wizard.

3) On the first page of the Farm Configuration Wizard, click Start the Wizard.

4) On the services configuration page, in the Services section, select the State Service check box.

5) Click Next.

6) Complete any other configuration steps for the server farm.

7) On the final page of the Farm Configuration Wizard, click Finish.

NOTE: If the State Service check box is unavailable, the State Service is already configured. To make changes to the configuration you must use Windows PowerShell.