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

This article has been archived. It is offered "as is" and will no longer be updated.
Problem description
When you use many SetCell calls in Excel Services, you may experience poor performance. This article helps you fix the problem.

To have us fix this problem for you, go to the “Fix it for me” section. If you would rather fix this problem yourself, go to the “Let me fix it myself” section.
Fix it for me
To fix this problem automatically, click the Fix this problem link. Then click Run in the File Download dialog box, and follow the steps in this wizard.

Note This wizard is temporarily in English only. However, the automatic fix also works for other language versions of Windows.

Note If you are not on the computer that has the problem, you can save the automatic fix to a flash drive or to a CD, and then you can run it on the computer that has the problem.

Now go to the "Did this fix the problem?" section.
Let me fix it myself
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
To fix this problem, follow these steps.
  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.
    8. Restart the computer.
Now go to the "Did this fix the problem?" section.
Did this fix the problem?
  • Check whether the problem is fixed. If the problem is fixed, you are finished with this article. If the problem is not fixed, you can contact support.
  • Visit the Fix it for me blog, or send us e-mail to provide feedback or to report any issues with this solution.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 955653 - Last Review: 01/16/2015 10:16:09 - Revision: 1.0

Microsoft Office SharePoint Server 2007, Excel Services in Microsoft Office SharePoint Server 2007

  • kbnosurvey kbarchive kbmsifixme kbfixme kbqfe kbprb kbexpertiseinter KB955653