Skip to content

Export to Excel

Kannan CPMember for 18 years 4 months
Created
2
2
0

Hi All,

I am in the process of resources/budgeted units export to excel, modify it and import back to P6.

While during the export of budgted unit value to excel- you might have noticed a green colour small icon in each cell at the top left corner. Is it possible to remove quickly without doing one by one, since there are thousands of activities. It is not possible to do the auto sum of the cells because of this icon.

Please share, if there is an easy idea

 

Thanks

Best Regards

Kannan

2 replies

Oldest first
  1. 0
    Kannan CP ·

    Hi All,I got the solution

    Hi All,

    I got the solution from Microsoft help.

     

    Kannan

  2. 0
    Zoltan Palffy ·

    highlight column then go to

    highlight column then go to data and select text to columns now you can autosum

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?