Learn why project completion dates change after importing in Primavera P6 and how to fix it by adjusting calendar settings. Step-by-step guide included.
Primavera P6 XER Import is slow / hanged when importing Risk Category and How to avoid this
When importing an Primavera P6 XER file, P6 Professional could be very slow or hanged when it starts to import Risk Category like the picture below. Primavera P6 Import with Risk Category These Risk Category comes from a Primavera model or database that use Risk Analysis application. If we do not use this Risk Analysis... Continue Reading →
Primavera P6 export to Excel. How to color WBS level automatically
When exporting the Activity Table from Primavera P6 to Excel, it can be difficult to visually distinguish between different WBS (Work Breakdown Structure) levels. In this guide, I’ll show you how to automatically color-code WBS levels in Excel, making your report easier to read—similar to how it appears in P6. Step 1: Add the WBS... Continue Reading →
Which Fields can be imported into Primavera P6 from Excel (XLS) Spreadsheet?
When you export data from Primavera P6 to Excel, you may notice that some column headers include an asterisk (*). What does this mean? Columns marked with an asterisk (*) in the exported Excel file indicate non-importable fields. This means: You cannot modify these fields in Excel and import them back into Primavera P6. These fields are typically calculated or rolled-up values,... Continue Reading →
Primavera SDK Excel File to import / export data
Even Oracle stop supporting the Excel File to import / export data, sometimes we still need to use it. The latest version it can support is P6 version 8.3 You can download it here: https://drive.google.com/open?id=0ByHnieTJNwKGRGpoMnJBS25HU28
Convert Microsoft Project MPP to MPX to import to Primavera
Usually Microsoft Project saves file as MPP format. However, Primavera allows us to import Microsoft Project files in MPX format. So, here is the tool help you to convert MPP to MPX. Download from Google Drive: https://drive.google.com/file/d/0ByHnieTJNwKGdGVybE5LaElOcnM/view?usp=sharing&resourcekey=0-9JeuQrLavBI1ix781GGGRQ Download from Onedrive: https://1drv.ms/u/s!Air459YMTPJdkMEVJTjjyOf6L-1QCg?e=Xqusjj
Export data to Excel with “lowest level” summary data only
In Primavera P6, you can use Activity Codes to group data in a flexible and customized way. After assigning Activity Codes and grouping activities based on them, the layout will display summarized data at different hierarchy levels: Sometimes, you may want to export only summary data to Excel. To do this, you can enable the... Continue Reading →
Can not import Layout
Your colleague sends you a Primavera XER file along with a Layout file. After successfully importing the project, you go to: Layout → Open → Import → Select the layout …and suddenly, an error appears: Your first reaction might be:“The layout file must be corrupted, I should ask them to resend it.” But wait, it’s... Continue Reading →

You must be logged in to post a comment.