Update Unit, Cost, Duration, and Percent Complete fields in Excel

When updating unit, cost, duration, and percent complete fields, you may want to import one updated field at a time, into P6 Professional. For example, you can export the Activities subject area, and update the activity percent complete and the remaining duration in the export file. When you import, PM updates the activity data. However, to update other activity values related to the remaining duration and percent complete, PM does not know which field was updated first. In PM, you cannot update these fields simultaneously.

To update unit, cost, duration, and percent complete fields

1. Make a copy of the export file.
2. In the copied file, update the necessary field for an activity.
3. In the selected activity row, use the Backspace or Delete key to null the remaining fields that are not unique, and those that are not marked with an asterisk (*). As a result, during import, only the field with the new value updates and PM calculates the other fields as necessary.
4. Import the file into the selected project. Repeat these steps for each unit, cost, duration, and percent complete field you want to update.