Importing data with P6 v 6.0
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
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