Skip to content
ProjectControls.com
Primavera Project Planner - P3

P3 TO EXCEL... URGENT

In the Open Standard
musawar ShaikhMember for 20 years
Created
7
1
0
Hi
Can anybody explain me how do we export our p3 project to excell..
Its very urgent
Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Eugene K ·
    #1
    Tools/Project Utility/Export...
    select WHAT u wnat to export
    remember to export in WK1 format.

    MS Excel can open WK1 files.

    but read in a thread that says MS Excel 2007 CANNOT open wk1.
    Report
  2. 0
    Anoon Iimos ·
    #2
    just copy & paste
    Report
  3. 0
    musawar Shaikh ·
    #3
    Thank you for quick reply.
    With the guidance of you I figured out p3 to excel . But still I am unable to transfer summary tasks with activites.
    Is it possible? to transfer summary task with activities??
    Report
  4. 0
    Santosh Bhat ·
    #4
    Your "summary tasks" are not in fact tasks at all, but just the organisational summaries. They cannot be exported.
    Report
  5. 0
    Amri Mansor ·
    #5

    Try use the following function.

    =min( ) for start date

    and

    =max( ) for finish date.

    Amri
    Report
  6. 0
    Essam Rushdi ·
    #6
    To transfer summary tasks with activites:

    Activity codes should be exported with activities.

    then you can finalized in Excel.

    Essam Rushdi
    Report
  7. 0
    Claus Wellendorf ·
    #7
    Summary activities can also be made as "WBS type" activities and exported as normal activities to excel. That is of course if you use wbs structure in your project and not only coding
    Report

Log in or join to reply

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

Log inJoin free

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