18 March, 2012

You do not have permissions to open this file on Excel Services


If you are troubled with the above errors in SharePoint while publishing and viewing the excel services forms in browser then I believe you are in the right place. I am not sure if my guidelines will solve your problem but at least it solved my issues.

Resolution:
1. In SharePoint Central Administration, go to 'Manage this farm's shared services'

2. Select your shared service. (Default is SharedServices1)

3. In 'Excel Services Settings' select Edit Excel Services settings.

4. Ensure that File Access method is Process Account. Click OK.

5. Back in 'Excel Services Settings' select 'Trusted File Locations'

6. Add a new Trusted file Location:
 > URL: Specify the report library or the entire portal

 > Location Type: Windows SharePoint Services

 > Children: Trusted

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 u

Office documents prompting for credentials

Multiple users are suddenly facing problems while accessing sharepoint site.

SYMPTOMS:
Users are prompted for credentials when accessing Office documents via ISA. 

Customer is using Forms-Based Authentication [FBA] to authenticate external users.

ERROR MESSAGE:
None

ENVIRONMENT:
Office SharePoint Server 2007

CAUSE:
ISA defaults to a settings "Never use persistent cookies"

Resolution:
On the SharePoint site - 

On the properties of the SharePoint publishing rule on ISA, 
go to the following location - Listener - Forms - Advanced Form Options - Cookie Settings - Use 
Persistent Cookies - set this to “On All Computers” (the default setting is “Never use persistent cookies”)

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.

Excel 2010 articles, fixes and updates - Year 2011


This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Excel 2010 that have been released in Year 2011


2555016 Excel 2010 may crash when using HP Printers Q2555016 KB2555016 June 13, 2011











2528533 Office 2010 Cumulative Update for April 2011 Q2528533 KB2528533 April 28, 2011



























2493730 Office 2010 Cumulative Update for February 2011 Q2493730 KB2493730 February 28, 2011




2273257 Office Application Custom Code Solutions Q2273257 KB2273257 February 21, 2011



2276904 Office Deployment Q2276904 KB2276904 January 12, 2011

2479673 Office 2010 Cumulative Update for December 2010 Q2479673 KB2479673 January 6, 2011

You are attempting to open a file that is blocked by your registry policy setting.

Number of error messages that will be fixed when you will apply the resolution:

You are attempting to open a file that is blocked by your registry policy setting.

You are attempting to open a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

You are attempting to open a file that was created in an earlier version of Microsoft Office. This file type is blocked from opening in this version by your registry policy setting.

You are attempting to save a file that is blocked by your registry policy setting.

You are attempting to save a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

Your error message will be anyone which are mentioned above. but don't worry Microsoft has already published a KB for this and your issue will be resolved when you will apply the mentioned resolution.

Resolution:
To resolve this issue, click the following article number under the name of the Office program that you are using to view the article in the Microsoft Knowledge Base: 

Word 2010, Word 2007, or Word 2003
Excel 2010, Excel 2007, or Excel 2003
PowerPoint 2010, PowerPoint 2007, or PowerPoint 2003
I receive an error message when I try to open or save a file in PowerPoint


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

The provided Secure Store target application is either incorrectly configured or does not exist


Yesterday, i was configuring Schedule PowerPivot Data Refresh as per this microsoft article: 
What i did exactly ?
-Open a SharePoint 2010 site
-Uploads Powerpivot
-selects schedule a data refresh for the workbook
-at step 7, i have selected third option i.e. The user enters a known existing Secure Store Target application ID in the Credentials section inside the "Connect using the credentials saved in Secure Store Service" field.
-Clicks OK to save the schedule and got the following error message:
"The provided Secure Store target application is either incorrectly configured or does not exist"

I have successfully resolved this issue by following the below mentioned steps:
Note: I am still debugging this issue to find out the root cause. Will share the details asap.

Resolution Steps:
1.       In Central Administration browse to Application Management 
2.       Click Manage Service Applications
3.       Click to the right of the Secure Store Application link so the row appears highlighted. The objective is to activate the Administrators button in the menu ribbon.  
4.       Click on the Administrators button and add the user (or an appropriate security group including user) to the field.  
5.       Click Add, and then check the "Manage target applications" check box.

If you have any queries/questions then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you