Resolving circular references in MS Project
A customer presented me with a project plan with thousands of tasks. Somewhere within that large list of tasks lurked one or more circular relationships and the error message did not help. The task to which the error message was pointing was not, as far as I could tell, part of the circular relationship.
I started scanning the project but there were so many defined dependencies I quickly gave up on that approach.
Instead I added the Predecessor column and an unused custom text column to the Gantt view and bulk copied the contents of the Predecessor column into Text20. Next I removed all of the predecessors with one massive delete resulting in something like the following:
Next I copied the contents of Text20 back into the Predecessors column and was presented with a series of error message that clearly identified the dependencies that were causing the problems.
Whew! That was a boring afternoon avoided.