Export to Excel

K
Kannan CP 👤 Member for 17 years 11 months

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

Z
Zoltan Palffy 👤 Member for 16 years 10 months

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

K
Kannan CP 👤 Member for 17 years 11 months

Hi All,

I got the solution from Microsoft help.

 

Kannan

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts