Cannot export to Excel while sub-units for duration/time are enabled

P6: Cannot export to Excel while sub-units for duration/time are enabled (Solved)

Posted by Hany Ismail
Date July 5, 2023
Categories Planning Using Primavera

If you faced this Error Message While Exporting your Excel Sheet.

The error message you encountered in Primavera P6 indicates that you have the “Sub-unit for the duration/Time” option enabled in your user preferences, and it is preventing the export to Excel. To resolve this issue, you need to disable the sub-unit option.

From the “Edit” menu, click on “User Preferences”.

Sub-units appear as the unit of any format so you can’t Export the Excel that contains these units

Choose “Time Units” to change the Sub-units.

You should enable the Sub-Units in Primavera P6 so you can export the Excel sheet.

Primavera Online Basic Course -English

FREE COURSE

Primavera Online Basic Course -English

Online Primavera P6 Course for Engineers & Construction Managers Learn how to use Oracle Primavera P6 to plan, schedule, monitor, and control…

5,444 students
WhatsApp support group
Certificate

You should remove the “Tick” sign in both the Sub-units for the “Units Format” and the Sub-units for the “Durations Format”.

So, you have to make your format as the following screenshot to be able to Export the Excel sheet.

If you try to export the Excel sheet again, it will be exported easily without any issues.

Download the Resources of this Article

P6: Cannot export to Excel while sub-units for duration/time are enabled (Solved) 411.59 KB 815 downloads

This File is included in the following course(s)

Intermediate, Professional Planning

Keep growing with Planning Engineer

Learn with a clear path

From Primavera P6 basics to claims, cost control and Power BI. Start with our free courses.

Get help on WhatsApp

Every course comes with a private WhatsApp support group where our team answers your questions.

Find planning jobs

106 open planning and project control jobs. Post your resume so employers can find you.

Get tips by email

Free planning tips, templates and course offers. Unsubscribe any time.

Follow us for new articles:

Do you want to know how to download this attachments?

Check this article to know how to download our website contents

In this guide, we’ll show you step by step how to access the articles’ resources, where to find them, and which part is free, which part is premium. We will introduce our freemium approach.

Tell Me How To Download

Hany Ismael is the founder and CEO of Planning Engineer Est. in Egypt. He has started his career back in 2003 as a site engineer, technical office engineer, planning engineer, planning manager, and finally planning department manager where he has been involved in several mega construction projects in Egypt and Saudi Arabia. In 2016, he established his own company in Egypt “Planning Engineer Est.” Hany gained his MSc degree in project management from Liverpool University-UK 2013-2016, PMP certified from PMI-USA 2010, and BSc Civil Engineer Tanta University-Egypt 2003. Hany provided more than 3,500 hours of planning and project management training on his website planningengineer.net, YouTube channel, and offline courses since 2011. He enjoys teaching project management in simple and practical way, and he developed several planning tools, techniques and courses.