Linking Problem in MS PRoject

[Rambo]

We are using a master.mpp file for a project and extracting selected tasks
line items for another file to which we are adding more detail to. We do not
want to affect the master file so we can't use bidirectional linking. What
we did do was create an excel spreadsheat and paste linked the entire master
into the spreadsheet. From there we created the detailed file by paste
linking to the cells in the spreadsheet.

Here's the problem. When someone adds a new task to the master.mpp file
everything updates properly. However, when a task in the master.mpp file is
deleted, the paste linked items in the detailed file are shifted off their
original location by one task line item which corrupts all the linked dates
and data.

How can we extract data from a master project into a another project without
affecting the master project (no shadow linked tasks)?

 

[Rod Gill]

You've hit the limits of an old technology that does the linking. It sounds
like you need some VBA code to automate this process or:

Set Flag1 to Yes for all tasks you want to have in the new plan. Create a
new master (but don't link). This creates a copy of all tasks.
Create a filter called Flag1 that only shows tasks with all flags set to
Yes.
A simple recorded macro can make creating the new master very quick and
easy. Save the new master each week as a historical record of schedule
progress.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz