How to update Unique Fields using excel and importing back to P6?

Hi Voltaire,

I understand what you are trying to do, but rather than trying to force it, I have another suggestion.

Open the project, go back to the Projects page, highlight the project, check out the Calculations tab.  There is a checkbox there called "Link Budget and At Completion for not started activities".   

This, I believe will do what you're trying to do in excel.  It happens often, if you've imported a microsoft project file, that the budgeted and at completion units are not the same for not started activities.

As a beginner, you might also be interested in some Primavera tutorials at http://www.planacademy.com

Good Luck,

Michael

any column heading with an * are not importable back into P6

however non labor units at completion should be able to be imported back into p6

as Mike suggested it might want to look at the "Link Budget and At Completion for not started activities"

also run this global change 

go to tools global change

new

where 

calculate cost from units equals yes

then 

calculate cost from units equals no

then select change on the right hand side

then select commit changes 

now try the importing again 

also go to the project directory make sure your project is highlighted

go to the calculations tab

on the rigt under resource assignments

make sure that 

under When updating Actual units or costs  that 

Subtract actual fro at completion is checked