Microsoft KB Archive/130102

{|
 * width="100%"|

MPRJ4: Hang After Reestablishing Links to Excel Worksheet

 * }

Q130102

-

The information in this article applies to:


 * Microsoft Project for the Macintosh, version 4.0
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a

-

SYMPTOMS
In Microsoft Project, when you open a file that contains an OLE link to a Microsoft Excel worksheet, when you choose to reestablish the link, you may receive the following error message

Cannot connect to link '!! '. Do you want to delete the link?

where , , and are the workbook, worksheet and cell reference in Microsoft Excel that contain the OLE linked information.

When you choose either Yes or No to delete the link, you receive the following error message

Sorry, a system error occurred.

"Microsoft Excel"

error type 11

and you must restart your Macintosh.

NOTE: In some cases, Project quits after displaying the linked information dialog box and causes the following error message:

The application "unknown" has unexpectedly quit, because an error of type 1 occurred.

CAUSE
This problem occurs if both of the following are true:


 * The project file that contains the OLE link also contains information that is linked to an open worksheet in Microsoft Excel (Note that this problem occurs even if the Microsoft Excel workbook that contains the linked information [source] and the workbook that contains the Microsoft Project OLE link [destination] are not the same workbook.)
 * The Clipboard contains OLE link information

WORKAROUND
To work around this problem, use any of the following methods.

Method 1
Save the Microsoft Excel file that contains the information that is linked to the Microsoft Project file before you open the Microsoft Project file.

Method 2
Before you open the Microsoft Project file that contains both information linked TO a Microsoft Excel worksheet and information linked FROM a Microsoft Excel worksheet, make sure that the clipboard does not contain OLE information by copying information from an application that does not support OLE, such as TeachText.