External Relationship Not Shown When Exported to Excel

Richard,

If Excel export works the same as P6 export, then you need to do two things to get P6 to export external relationships to Excel.

1) The schedule has to have its CPM optional calculation settings set to not ignore external relationships.

2) You need to open all of the ‘external’ schedules at the same time as you open the one schedule you want to export.

These two things tell P6 that you also want to export the ‘open’ relationships. Good luck!

Hi Ronald,
I am respecting the two points that you mentioned but still the exported Excel file does not show the external relationships.
By the way, for making the export I use the following while opening all linked projects into P6 :
go to menu File -> Export -> Spreadsheet-(XLS) -> Activity Relationships -> I select the project I want to export -> select the template (without specifying any filter inside it) ->.....

The key is in "I select the project I want to export".

You can only export one project at a time using the excel functionality, so there is no way to get the external relationships.

You need to use the XER export to get relationships to other projects and even then all the projects have to be open at the same time (as Ron said).

The XER parser tool is very useful to manipulate data. It’s not as easy to use as the Excel import/export but it is much more powerful. It’s available on the knowledgebase.

Ian


http://www.emerald-associates.com