Microsoft KB Archive/111279

Project: Error When Updating Multiple Project Links in Excel

PSS ID Number: Q111279 Article last modified on 10-20-1995

3.00 3.00a

WINDOWS

= SYMPTOMS =

Microsoft Excel worksheets that contain links to multiple Microsoft Project files update only the first link when the worksheet is opened. The remaining links to the Microsoft Project files are not updated.

= CAUSE =

When you update linked information when Microsoft Project is the source application, Microsoft Project and the source project file must already be open. Otherwise, the application that updates the files will attempt to open Microsoft Project multiple times and cause the following error message:

Microsoft Project is Already Running.

Microsoft Project cannot be opened multiple times.

= WORKAROUND =

To update all the links, run Microsoft Project first, open the project files that are linked into the Microsoft Excel worksheet, and then open the Microsoft Excel worksheet.

= MORE INFORMATION =

Steps to Reproduce Problem

 * 1) From the File menu, choose New.
 * 2) Enter a new task called Task1.
 * 3) From the File menu, choose Save As, and type the name of the project file (PROJECT1.MPP).
 * 4) Repeat Steps 1-3 to create PROJECT2.MPP.
 * 5) From the Window menu, choose PROJECT1.
 * 6) Select the first task name, and from the Edit menu, choose Copy.
 * 7) In Microsoft Excel, from the Edit menu, choose Paste Link.
 * 8) In Microsoft Project, from the Window menu, choose PROJECT2.
 * 9) Repeat steps 6-7.
 * 10) From the File menu, choose Save As. Type the name of the worksheet file (SHEET1.XLS).
 * 11) From the File menu, choose Close (close the Excel spreadsheet).
 * 12) In Microsoft Project, from the File menu, choose Exit.
 * 13) In Microsoft Excel, open SHEET1.XLS.
 * 14) When Microsoft Excel asks to update links, choose Yes.

When Microsoft Excel asks to activate Project for the second time, you will receive an error message.

KBCategory: kbusage KBSubcategory:

Additional reference words: 3.00 3.00a update DDE single dynamic data exchange object linking embedding OLE ============================================================================= Copyright Microsoft Corporation 1995.