You may experience poor performance when you use many SetCell calls in Excel Services

Article translations Article translations
Article ID: 955653 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you use many SetCell calls in Excel Services, you may experience poor performance.

RESOLUTION

To resolve this issue, follow these steps. Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
  1. Apply hotfix 955144. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    955144 Description of the Excel Services in SharePoint Server 2007 hotfix package: July 11, 2008
  2. Set the WebServiceSessionCloningDisabled registry entry. To do this, follow these steps:
    1. Click Start, click Run, type regedit, and then click OK.
    2. Locate and then click the following registry subkey:
      HKEY_LOCAL_MACHINE\Software\Microsoft\Office Server\12.0\Excel Services
    3. On the Edit menu, point to New, and then click DWORD Value.
    4. Type WebServiceSessionCloningDisabled, and then press ENTER.
    5. Right-click WebServiceSessionCloningDisabled, and then click Modify.
    6. In the Value data box, type 1, and then click OK.
    7. Exit Registry Editor.

Properties

Article ID: 955653 - Last Review: August 1, 2008 - Revision: 1.0
APPLIES TO
  • Microsoft Office SharePoint Server 2007
  • Excel Services in Microsoft Office SharePoint Server 2007
Keywords: 
kbqfe kbprb kbexpertiseinter KB955653

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com