Skip to content

Export relationships to .xlsx Excel

Alvaro MansoMember for 12 years 10 months
Created
5
1
0

Hi everybody.

This is my first input to planningplanet. Sorry if it was answered in the past. I coudnt find anything about it.

 

The point is that the projects I usually hande have more than 65000 relatioships. I use P6 version 15.1 and the only export format I get is in Excel (.xls). And that kind of excel have a limitation of 65000 rows.

Is there any way to get an export on .xlsx (Excel 2010 or above) directly from P6? It's getting impossible to export all relationships at a time whe my projects reach maturity.

Thank you in advance

5 replies

Oldest first
  1. 0
    David Kelly ·

    No.There are very clever

    No.

    There are very clever commercial solutions to your problem.  Probably the best out-of-the-box solution is to export an XER file, and edit it. Not difficult, just not very automated.......

  2. 0
    Zoltan Palffy ·

    just do it in parts that

    just do it in parts that equal 65000

  3. 0
    Emad Mofarej,PMP,PSP,CDT,CCM ·

    Create a relationship report

    Create a relationship report and add whatever column you want in it and save it in csv or txt format of your choice.

    But if you are just looking for the complete list of relationships you really don't need any of them!

    Go to Report window > click on the create new report button> Select activity relationships. select column that you need and group and sort and filter of your choice and run it ans save it as Delimited Text File and use CSV as the file extension. you can then open it in excel.

     

    In case you are trying to modify those relationships you can use third party softwares. The best free software is XERfileparser. I don't get into that since I don't want to bore you with the details of how modify relationships directly in XER or by using the third party softwares.

  4. 0
    Emad Mofarej,PMP,PSP,CDT,CCM ·

    Create a relationship report

    Create a relationship report and add whatever column you want in it and save it in csv or txt format of your choice.

    But if you are just looking for the complete list of relationships you really don't need any of them!

    Go to Report window > click on the create new report button> Select activity relationships. select column that you need and group and sort and filter of your choice and run it ans save it as Delimited Text File and use CSV as the file extension. you can then open it in excel.

     

    In case you are trying to modify those relationships you can use third party softwares. The best free software is XERfileparser. I don't get into that since I don't want to bore you with the details of how modify relationships directly in XER or by using the third party softwares.

  5. 0
    Emad Mofarej,PMP,PSP,CDT,CCM ·

    Create a relationship report

    Create a relationship report and add whatever column you want in it and save it in csv or txt format of your choice.

    But if you are just looking for the complete list of relationships you really don't need any of them!

    Go to Report window > click on the create new report button> Select activity relationships. select columns that you need (probably pred activity id, description, rel type, lag, successor act id and desc, etc)  and group and sort and filter of your choice and run it ans save it as Delimited Text File and use CSV as the file extension. you can then open it in excel.

     

    In case you are trying to modify those relationships you can use third party softwares. The best free software is XERfileparser. I don't get into that since I don't want to bore you with the details of how modify relationships directly in XER or by using the third party softwares.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?