XL2000: Linked Files Updated Much More Slowly Than in Earlier Versions of Excel

• Microsoft Excel 2000

SYMPTOMS

When you click Yes to update the links on a workbook that you are opening, Microsoft Excel appears to stop responding (hang). After a long wait, the links are updated, and you gain control of the worksheet.

The same workbook may have been updated much more quickly in earlier versions of Excel.

CAUSE

This problem may occur when the following conditions are true:

• Your workbook contains a large number of links to one or more Excel workbooks.


-and-


• Many of the linked cells contain formulas that use the VLOOKUP or HLOOKUP functions.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL2000 lookup

Keywords : xlloadsave xlformula
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug