22 August, 2012

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.

21 August, 2012

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