Broken links

S

SheriTingle

Thanks for the help. I am using Project 2003. Is there a quick way to search
for broken or missing links without visually scrolling through the entire
project?

I have around 500 tasks and I think some links were skipped when the project
was first created and I know some were deleted. Any suggestions on a fast way
to locate these problem lines?
 
J

JackD

If you are just talking about tasks with no successors then you can filter
for that pretty simply. If you think that some links (but not all links) for
a specific task are lost, then you have a problem which is probably
insolvable.

For the former, just run a macro like this:

Sub dangling()
For Each Task In ActiveProject.Tasks
If Not Task Is Nothing Then
Task.Flag1 = False
If Task.SuccessorTasks.Count = 0 Then
Task.Flag1 = True
End If
End If
Next Task
End Sub

Then filter for any task that has Flag1 set to yes. You can include creating
and applying the filter in the macro as well. Easiest to use the macro
recorder to get the code for that step.
 
J

John

JackD said:
If you are just talking about tasks with no successors then you can filter
for that pretty simply. If you think that some links (but not all links) for
a specific task are lost, then you have a problem which is probably
insolvable.

For the former, just run a macro like this:

Sub dangling()
For Each Task In ActiveProject.Tasks
If Not Task Is Nothing Then
Task.Flag1 = False
If Task.SuccessorTasks.Count = 0 Then
Task.Flag1 = True
End If
End If
Next Task
End Sub

Then filter for any task that has Flag1 set to yes. You can include creating
and applying the filter in the macro as well. Easiest to use the macro
recorder to get the code for that step.

Jack,
A macro isn't necessary to set up a filter. I simply use the following
filter:
And/Or Field Name Test Value(s)
Successors is less than 1

John
 
J

JackD

John said:
Jack,
A macro isn't necessary to set up a filter. I simply use the following
filter:
And/Or Field Name Test Value(s)
Successors is less than 1

John

I thought that would work too, but I tried "equal to" 0 and it did not work.
Odd that "less than 1" would work when equal to 0 does not...

-Jack
 
J

John

JackD said:
I thought that would work too, but I tried "equal to" 0 and it did not work.
Odd that "less than 1" would work when equal to 0 does not...

-Jack

Jack,
Yeah I don't know why it works but I've been using it for years - part
of the mystery of our "favorite" application I guess :)

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top