Skip to content
ProjectControls.com
Primavera Project Planner - P3

Export P3 files to Excel Pls.HELP!!!!!!!!!

In the Open Standard
Hesham HaridiMember for 19 years
Created
4
1
0
Hi all,
realy i face a problem when i export P3 file to excel if this project exceed on 2500 activities how can overcom on this problem.
Regards...
Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Alexandre Faulx-Briole ·
    #1
    Try to export to a dbf file, then open it in Excel
    Alexandre
    Report
  2. 0
    James Barnes ·
    #2
    hesham

    Are you exporting to .WKS or .DBF?

    Always export to .DBF, .WKS does act funny with larger plans and I think has a restriction on total number of activities.

    If you are exporting to manipulate the data and re-import, take care to check your data properly as some flavours of excel don’t handle .DBF files too well and will sometimes snip data (and I think perhaps the newest versions don’t support .DBF at all...?). Back up the "clean" plan before committing to the import aswell.
    Report
  3. 0
    Pranab Kumar Deb ·
    #3
    Hello Hesham,
    WKS supports only 2048 activities so u have to do the export import in two or more times or do it by selecting .dbf in export and import.
    regards
    deb
    Report
  4. 0
    Rajesh Moolakkandam ·
    #4
    Hi Hesham haridi,

    Export to .DBF format only. Then you save to .xls and format the cells. .WKS is limited to around 2000 activities only.

    Rajesh M
    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?