XL2000: Linked Excel Sheet Appears to Make Computer Stop Responding (215155)



The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Access for Windows 95 7.0

This article was previously published under Q215155

SYMPTOMS

When you use a version of Microsoft Access earlier than Access 97 to link to a very large Microsoft Excel spreadsheet, your computer may appear to stop responding when you attempt to create a report.

CAUSE

This behavior can occur because it may take 30 minutes or more to create a report when a version of Access earlier than Access 97 is linked to a very large Excel worksheet.

NOTE: A marginally adequate computer (Pentium 100 with 32 megabytes [MB] of RAM) may take more than 4 hours to complete this task.

RESOLUTION

Your computer has not stopped responding, and everything operates as expected after the report has been created.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Modification Type:MajorLast Reviewed:10/8/2003
Keywords:kbbug kbnofix KB215155