Primavera P6 export to Excel. How to color WBS level automatically

After export activity table from Primavera P6 to Excel, it’s very hard to distinguish WBS level. I will show you how to color WBS level automatically so we can have report like in P6. Step 1: Follow this article to insert the "WBS Level" column : https://doduykhuong.com/2018/04/01/primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity/ Step 2: Go to Conditional Formatting -> Manage Rules Create... Continue Reading →

Advertisements

Which Fields can be imported into Primavera P6 from Excel (XLS) Spreadsheet?

When we look at Excel file exported from Primavera P6, there are some columns have an asterisk (*). What does it mean? I will explain in this article. All the columns which have the asterisk mean they can not be imported into P6, i.e. we can not change their value and import into P6. There is... Continue Reading →

Can not import Layout

Your colleague send you Primavera XER file and Layout file. After you import project successfully, you click on Layout -> Open -> Import -> Select the layout. And this error appear: You may think "Wow, this layout file must be damaged. I need to tell him to send me again". Wait! It's not because of... Continue Reading →

Create a website or blog at WordPress.com

Up ↑