XL2000: Hyperlinks in Embedded Excel Workbook Do Not Work

• Microsoft Excel 2000
• Microsoft Excel 97 for Windows
• Microsoft Access versions 2000, 97
• Microsoft Outlook, versions 2000, 97, 98
• Microsoft PowerPoint versions 2000, 97 For Windows
• Microsoft Visual C++, 32-bit Professional Edition, versions 5.0, 6.0
• Microsoft Visual Basic Professional and Enterprise Editions for Windows, versions 5.0, 6.0
• Microsoft Office 2000 Developer

SYMPTOMS

When you click a hyperlink in an embedded Microsoft Excel workbook, Excel generates the following error and does not select the range indicated by the hyperlink:

An Unexpected Error Has Occurred

CAUSE

This problem occurs when you embed either a new or existing Excel workbook. The problem does not occur when you link to an existing workbook.

The error occurs with the following containers:

• Microsoft Visual C++ Application



• Microsoft Visual Basic Application



• Microsoft Access



• Microsoft PowerPoint



• Microsoft Outlook


NOTE: The problem does not occur when you embed an Excel workbook in a Microsoft Word document.

WORKAROUND

To work around this problem, you can link to the Microsoft Excel workbook instead of embedding it. Note that a linked object cannot be edited in-place; the linked object will be opened in a new window for editing.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 and 2000.

MORE INFORMATION

Steps to Reproduce Problem

1. Start a new presentation in Microsoft PowerPoint 2000.



2. Click Object on the Insert menu.



3. When the Insert Object dialog box appears, select Microsoft Excel Worksheet in the Object Type list, and click OK. The embedded workbook will be activated in-place.



4. With cell A1 selected, right-click and choose Hyperlink on the shortcut menu. Choose Place in this Document for Link to, type B5 for the cell reference, and then click OK.



5. Click the hyperlink in A1. You receive the error:

   An unexpected error has occurred

   To work around this problem, link to an existing Excel workbook. To link to a workbook using the steps above, in step 3, when the Insert Object dialog box appears, select Create From File, click Browse to locate the workbook, check the Link checkbox, and then click OK.

Additional query words: XL2000

Keywords          : kbole kbAutomation kbExcel kbInplaceAct kbGrpDSO kbOffice2000 kbexcel2000 
Version           : WINDOWS:2000,5.0,6.0,97,98; winnt:5.0,6.0; :
Platform          : WINDOWS winnt 
Issue type        : kbbug 

Last Reviewed: June 8, 1999