Microsoft KB Archive/215764

From BetaArchive Wiki
Knowledge Base


XL2000: Excel4 Macro Runs Slowly When Excel Is in the Background

Article ID: 215764

Article Last Modified on 11/5/2003



APPLIES TO

  • Microsoft Excel 2000 Standard Edition



This article was previously published under Q215764

SYMPTOMS

When you run a macro that uses MS Excel 4.0 Macro (XLM) code, it takes more time to be completed than you expect.

CAUSE

This behavior occurs when you switch to another program (or task) in your operating system, so that Microsoft Excel is no longer running as the foreground task.

NOTE: Some Excel add-ins, such as Solver, use XLM code internally. If you create a Microsoft Visual Basic for Applications macro that calls one of these add-ins, you may also experience these symptoms.

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)


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 corrected in Microsoft Office 2000 SR-1/SR-1a.


Additional query words: XL2000

Keywords: kbbug kbfix KB215764