Q130102 - MPRJ4: Hang After Reestablishing Links to Excel Worksheet

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 '<Workbook>!<Sheet>!<cellref>'. Do you want to delete the link?

where <Workbook>, <Sheet>, and <cellref> 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.)

-and-

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.

REFERENCES

For more information about "Linking And Embedding Objects", choose the Search button in Help and type:

OLE: linking

Additional query words: 5.00a mxl5 freeze crash lock lockup

Keywords :
Issue type : kbbug
Technology : kbHWMAC kbOSMAC kbExcelSearch kbProject400Mac kbExcelMacsearch kbProjectMacSearch kbExcel500Mac kbExcel500aMac