Skip to content

Editing the Import datas from Excel

Haresh JayanthMember for 20 years 1 month
Created
6
2
0
Dear All,

I exported my program from P6 to Excel and input Budgeted cost in excel in Projcost sheet.

After loading the cost, i imported back the file to P6.

But now , i am not able to edit the budgeted cost column in P6.

Can anybody suggest any solution to edit the budgeted cost column??

regards,

6 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    Haresh,

    Are you referring to Expenses cost under Expenses tab? Which project cost column are you referring?
  2. 0
    Ferdinand U. ·
    Maybe, you are showing the Budgeted Total Cost in the Column?

    Show instead the Budgeted Labor or Material Cost in the Column
  3. 0
    Haresh Jayanth ·
    Let me explain again clearly.......

    First I exported my P6 program to excel. Then i loaded cost in excel in "ProjCost" sheet and then again imported back to P6.

    Now i have cost loaded in "Budgeted Total cost", whereas Project material cost and Project Labour cost column shows no cost.

    But now i cannot edit the data in the budgeted total cost column in P6.

    Any solution pls..
  4. 0
    Rodel Marasigan ·
    Haresh,
    You are trying to edit a non-editable column which is a summation of Labor Cost, Non Labor cost, Material cost and expenses. If you import a cost using "ProjCost" meaning you used Expenses table. You can edit the cost under Expenses tab on Activity Detail.
  5. 0
    Haresh Jayanth ·
    Dear Rodel,

    Thanks for solving the problem......I want to learn from u in future.

    regards,

    Haresh
  6. 0
    Rodel Marasigan ·
    No worries!!!
    I’m happy to help.
    Smile

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?