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
 

--------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Project for Windows, versions 3.0,3.0a.
--------------------------------------------------------------------
 
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.
