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. Its not as easy to use as the Excel import/export but it is much more powerful. Its available on the knowledgebase.
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) ->.....
Member for
22 years 9 months
Member for22 years10 months
Submitted by Ronald Winter on Wed, 2010-03-03 10:25
Member for
15 years 9 monthsRE: External Relationship Not Shown When Exported to Excel
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. Its not as easy to use as the Excel import/export but it is much more powerful. Its available on the knowledgebase.
Ian
http://www.emerald-associates.com
Member for
15 years 9 monthsRE: External Relationship Not Shown When Exported to Excel
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) ->.....
Member for
22 years 9 monthsRE: 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!