Importing data with P6 v 6.0

E
Eric EVRARD 👤 Member for 19 years 6 months
A
Arnold Puy 👤 Member for 19 years 1 month

Hi Eric,



The Duration % Complete cannot be modified using Excel sheet due to (*) sign while Actual Start can be changed. If you want to alter your Duration % complete in excel then you need to create and assign the UDF (User Defined Fields) say DUR%COMP.



The UDF need to include during exporting data and change it using excel sheet. When done, export it back to P6.



Create and Run a global change with corresponding parameters:



Duration % complete = DUR%COMP



Make sure before running the global change you need to have the actual start for each activities to be updated.



Regards,



Arnold

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts