Tuesday, November 29, 2011

Unable to process the request (While opening an Excel document)

On opening the excel document stored in a document library it shows 'Unable to process the request. Wait a few miniutes and try performing this operation again.

To solve this, edit the 'serverfilesExcelServer.xml' available in the SharePoint 14 hive.

'C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML'

Comment the lines containing the file extension of xlsx or xls.

<?xml version=”1.0″ encoding=”utf-8″ ?>
<!– Copyright (c) Microsoft Corporation. All rights reserved. –>
<ServerFiles>
     <!–<Mapping FileExtension=”xlsx” RedirectUrlTemplate=”/_layouts/xlviewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate=”/_layouts/xlviewer.aspx?new=1″/> –>
     <Mapping FileExtension=”xlsb” RedirectUrlTemplate=”/_layouts/xlviewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate=”/_layouts/xlviewer.aspx?new=1″/>
     <Mapping FileExtension=”xlsm” RedirectUrlTemplate=”/_layouts/xlviewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate=”/_layouts/xlviewer.aspx?new=1″/>
 </ServerFiles>


Then perform an IISRESET which solves the problem.

No comments:

Post a Comment