blocked file types in SharePoint Server 2010

Listed below are all file types that are blocked by default.

.ade	Microsoft Access project extension
.adp	Microsoft Access project
.app	Application file
.asa	ASP declarations file
.ashx	ASP.NET Web handler file. Web handlers are software modules that handle raw HTTP requests received by ASP.NET.
.asmx	ASP.NET Web Services source file
.asp	Active Server Pages
.bas	Microsoft Visual Basic class module
.bat	Batch file
.cdx	Compound index
.cer	Certificate file
.chm	Compiled HTML Help file
.class	Java class file
.cmd	Microsoft Windows NT command script
.com	Microsoft MS-DOS program
.config	Configuration file
.cpl	Control Panel extension
.crt	Security certificate
.csh	Script file
.dll	Windows dynamic-link library
.exe	Program
.fxp	Microsoft Visual FoxPro compiled program
.hlp	Help file
.hta	HTML program
.htr	Script file
.htw	HTML document
.ida	Internet Information Services file
.idc	Internet database connector file
.idq	Internet data query file
.ins	Internet Naming Service
.isp	Internet Communication settings
.its	Internet Document Set file
.jse	JScript Encoded script file
.ksh	Korn Shell script file
.lnk	Shortcut
.mad	Shortcut
.maf	Shortcut
.mag	Shortcut
.mam	Shortcut
.maq	Shortcut
.mar	Shortcut
.mas	Microsoft Access stored procedure
.mat	Shortcut
.mau	Shortcut
.mav	Shortcut
.maw	Shortcut
.mda	Microsoft Access add-in program
.mdb	Microsoft Access program
.mde	Microsoft Access MDE database
.mdt	Microsoft Access data file
.mdw	Microsoft Access workgroup
.mdz	Microsoft Access wizard program
.msc	Microsoft Common Console document
.msh	Microsoft Agent script helper
.msh1	Microsoft Agent script helper
.msh1xml	Microsoft Agent script helper
.msh2	Microsoft Agent script helper
.msh2xml	Microsoft Agent script helper
.mshxml	Microsoft Agent script helper
.msi	Microsoft Windows Installer package
.msp	Windows Installer patch package file
.mst	Visual Test source files
.ops	Microsoft Office profile settings file
.pcd	Photo CD image or Microsoft Visual Test compiled script
.pif	Shortcut to MS-DOS program
.prf	System file
.prg	Program source file
.printer	Printer file
.pst	Microsoft Outlook personal folder file
.reg	Registration entries
.rem	ACT! database maintenance file
.scf	Windows Explorer command file
.scr	Screen saver
.sct	Script file
.shb	Windows shortcut
.shs	Shell Scrap object
.shtm	HTML file that contains server-side directives
.shtml	HTML file that contains server-side directives
.soap	Simple Object Access Protocol file
.stm	HTML file that contains server-side directives
.url	Uniform Resource Locator (Internet shortcut)
.vb	Microsoft Visual Basic Scripting Edition (VBScript) file
.vbe	VBScript Encoded Script file
.vbs	VBScript file
.ws	Windows Script file
.wsc	Windows Script Component
.wsf	Windows Script file
.wsh	Windows Script Host settings file

"Setup is missing prerequisites" error message when you try to install the PowerPivot add-in for Excel in FAST Search Server 2010 for SharePoint

Problem Description:

Consider the following scenario:

• You have a server that has the Business Intelligence Indexing Connector feature installed in Microsoft FAST Search Server 2010 for SharePoint. 

• You have to crawl Microsoft Excel 2010 files that contain PowerPivot content. 

• You install the PowerPivot add-in for Excel on the server. 

In this scenario, the PowerPivot add-in for Excel does not install.

Additionally, you receive the following error message:

Setup is missing prerequisites:

This add-in requires Excel 2010. If you have 32-bit Excel, you must install the 32-bit version of the add-in. If not, you must install the 64-bit version. This add-in requires that the Office Shared Features component of Microsoft Office 2010 is installed.

Go to http://go.microsoft.com/Fwlink/?LinkId= 168472

Probable cause:

This issue occurs because Excel 2010 is not installed on the server.

Resolution:

To resolve this issue, install Excel 2010 on the server.

OR—Follow this article: http://support.microsoft.com/kb/982765

Please let me know in case of any queries/questions.

I would be more than happy to help you as well as resolves your issues, Thank you J

Note: When installing PowerPivot add-in for Excel, you don’t look at whether you have a 32-bit machine or a 64-bit machine; instead, you should look at whether you have 32-bit Excel or 64-bit Excel. In other words, if you are using the 32-bit version of Excel 2010, you must use the 32-bit version of PowerPivot and if you are using the 64-bit version of Excel 2010, you must use the 64-bit version of PowerPivot.

whenever he clicks on excel spreadsheets, its says unable to process request

Problem Description:

Receive the following error when an Excel Document is attempted to be opened in Internet Explorer and would like to have the users be prompted to open Excel Documents in Excel instead of in IE, by default.

Error Message:

Unable to process the request

Wait a few minutes and try performing this operation again.

Probable cause:

Library settings are configured to open documents in IE by default and the Desktop Experience is not installed on the server.

Resolutions:

Solution#1:

Modified the library advanced settings to open the Excel Document in Excel by default:

1)   Opened the library selected Library Settings from the Library Ribbon

2)   Selected Advanced Settings

3)   Selected ‘Open in the client application’ in the Opening Documents in the Browser section

4)   Clicked OK

5)   Verified that the Excel Documents were opening in Excel

Solution#2:

Make sure the excel services are running

Solution#3:

Make sure that web application has Excel service connection. How 2 check this:

·         Central Administration

·         Manage web applications

·         Service connections

·         Make sure the option of ‘Excel service application’ is marked

Solution#4:

Make sure that your server has this hotfix installed: KB976462

Solution#5:

On document library level – you can go to Library Settings -> Advanced settings and change “Default open behavior for browser-enabled documents” to “Open in the client application”

Solution#6:

Activate this feature ‘Open Documents in Client Applications by Default’

How to activate this:

§  Open the SharePoint site

§  Site actions

§  Site settings

§  Site collection administration

§  Site collection features

§  Run IISRESET command

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 J Thank you

Error message when you open a Web page that uses Excel Web Access in SharePoint Server 2007: "You do not have permissions to open this file on Excel Services" or "Excel cannot load the workbook that you requested"

An Excel Access Web Part is a SharePoint technology that displays an Excel workbook from a document library. You can connect an Excel Web Access Web Part to any workbook in a SharePoint document library, and then use it on a dashboard or other SharePoint page. For example, you might want to display selected elements of a quarterly report on a dashboard.

Problem description:

You open a Web page that uses Excel Web Access in Microsoft Office SharePoint Server 2007. If Excel Web Access uses a file from a UNC path that is in a trusted location, the file does not open.

Additionally, you receive one of the following error messages:

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.

Excel Services cannot load the workbook that you requested.

Workarounds:

To work around this issue, use one or more of the following methods, as appropriate for your situation:

• Make sure that the location type for the trusted location is in UNC format. 

• Make sure that the file access method on the server is set to process account. 

• Make sure that the account that is running Excel Services has permissions to access the UNC share. 

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 J Thank you