Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Coloring and grouping a WBS in excel from P6 copy and paste

No replies
Zoltan Palffy
User offline. Last seen 4 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

Sometimes it is useful to copy and paste schedule information from Primavera P6 to excel in wbs format.

Howerver, whenever you paste information from P6 into excel the color fomatting and the ability to group by wbs doe snot carry over.

There is an excel wbs add in utility that can color your wbs and add the ability to exapnd and or collapse the wbs and inforamtion.

This is a handy utility so that other people who do not have Primavera P6 or who do not know how to use P6 can use excel to view schedule information in a wbs format coloring and grouping similiar to P6.

Here is a link to the excel add-in uility. 

https://planlamamuhendisi.com/wbs-organizer.html