Forum Sponsor:

An innovation in P6 Professional training from RPCuk in partnership with Oracle. All the topics that matter to you in workshops customised to your role and industry.  Now get superior training value when you book our Blended Learning Bundle. Learn more here.

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

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.

Exporting Problem from Primavera to Excel

5 replies [Last post]
Kien Dinh
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 19 Jul 2019
Posts: 5
Groups: None

Dear All,

To day I have tried to export a P6 file to Excel format but unlucky it appeared to be failed, the dialog box said that: "Cannot export while sub-unit for duration/time are enable". I have tried in several ways to solve it but still failed. Anyone know this and advise me would be much appriciated.

 Thanks

Replies

Zoltan Palffy
User offline. Last seen 5 days 3 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2361
Groups: None

glad that I coud help you 

Kien Dinh
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 19 Jul 2019
Posts: 5
Groups: None

Dear sỉ,

Trying this way has solved the issues. 

 DQK

Zoltan Palffy
User offline. Last seen 5 days 3 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2361
Groups: None

go to edit users prefernces

then on tthe time units tab under Units format uncheck Sub-unit

and also under Durations format uncheck sub-units

Kien Dinh
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 19 Jul 2019
Posts: 5
Groups: None

Dear Zoltan,

Thank for the reply. I have verified both the Window and P6 for decimal and digit. After that, I tried to export P6 again but it still didn't work. Perhap the decimal and digit was not the cause for the exporting problem.

6885
untitled.png

Zoltan Palffy
User offline. Last seen 5 days 3 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2361
Groups: None

Issue is caused by the Windows Regional Settings having an inconsistent Decimal symbol and Digit grouping symbol then the Decimal Symbol and Digit grouping symbol in P6 Professional.

To ensure that Decimal symbol and Digit grouping symbol for both P6 Professional and the Windows Region and Language settings, under Customize Format, match and are consistent with the desired currency please do the following:

Make sure that these match 

For the Windows OS Region and Language settings:

  1. Launch the Windows OS Control Panel
  2. Select 'Region'
  3. Select 'Additional Settings'
  4. Select the 'Currency' tab
  5. Review the 'Decimal symbol' and 'Digit grouping symbol'

For P6 Professional

 

  1. Access P6 Professional
  2. Select 'Currencies' under the 'Admin' menu item
  3. Review the 'Decimal symbol' and 'Digit grouping symbol'make sure that