Microsoft KB Archive/305949

= XL2000: CPU Usage Spikes at 100 Percent When Excel Is Running in the Background =

Article ID: 305949

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q305949



SYMPTOMS
When Microsoft Excel is running in the background, CPU usage may spike to 100 percent. If Excel is hosted on a terminal server, the server's CPU usage may spike, which slows the response time for everyone on the server.



CAUSE
This problem occurs when the File Now Available dialog box or the AutoSave dialog box is displayed.

&quot;File Now Available&quot; Dialog Box
The File Now Available dialog box appears when the following conditions are true:
 * 1) You open a file that another user already has open.
 * 2) In the File in Use dialog box, you click Notify, to be notified when the other user closes the file.
 * 3) You switch to any other program, so that Excel is running in the background.
 * 4) The other user closes the file.
 * 5) You receive the &quot;File name is now available for editing&quot; message in the File Now Available dialog box.

The CPU usage remains at 100 percent until you respond to the File Now Available dialog box.

AutoSave Dialog Box
The AutoSave dialog box appears when the following conditions are true:
 * 1) You select the AutoSave Add-in check box. (On the Tools menu, click Add-Ins.)
 * 2) You select the Prompt Before Saving check box in the AutoSave dialog box. (On the Tools menu, click AutoSave.)
 * 3) You make a change in the active workbook.
 * 4) You switch to any another program, so that Excel is running in the background.
 * 5) The AutoSave time interval passes, and the AutoSave dialog box appears, asking you to save the files.

The CPU usage remains at 100 percent until you respond to the AutoSave dialog box.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft Office 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

276367 OFF2000: How to Obtain the Latest Office 2000 Service Pack

The English version of this fix should have the following file attributes or later:   Date         Time      Version   Size       File name -  27-SEP-2001  20:49:50            1,849,336  Excel.msp After the patch is installed, the application will have the following file attributes:   Date         Time      Version   Size       File name -  11-SEP-2001  14:52:38  9.0.5706  7,159,853  Excel.exe

Temporary Workaround
To temporarily work around this problem, use the appropriate method for your situation.

Method 1: If the &quot;File Now Available&quot; Dialog Box Causes the Problem
Share the workbook, so that multiple users can have read/write access. To do this, follow these steps:
 * 1) Open the workbook.
 * 2) On the Tools menu, click Share Workbook.
 * 3) On the Editing tab, click to select the Allow changes by more than one user at the same time check box.
 * 4) Click OK.

NOTE: Shared workbooks have limited functionality. For more information about about the limitations of shared workbooks, click Microsoft Excel Help on the Help menu, type limitations of shared workbooks in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Method 2: If the AutoSave Add-in Causes the Problem
Clear the Prompt Before Saving check box. To do this, follow these steps:
 * 1) On the Tools menu, click AutoSave
 * 2) In the AutoSave dialog box, click to clear the Prompt Before Saving check box.
 * 3) Click OK.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft Office 2000 Service Pack 3 (SP-3).

Keywords: kbbug kbfix kbqfe kboffice2000sp3fix kbhotfixserver KB305949

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.