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.

Exporting Problem from Primavera to Excel

5 replies [Last post]
Fri, 2019-07-19 04:08
Kien Dinh
User offline. Last seen 4 years 31 weeks 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

Top

Replies

Tue, 2019-07-23 13:03
#1
Zoltan Palffy
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

glad that I coud help you 

Top
Tue, 2019-07-23 07:35
#2
Kien Dinh
User offline. Last seen 4 years 31 weeks ago. Offline
Joined: 19 Jul 2019
Posts: 5
Groups: None

Dear sỉ,

Trying this way has solved the issues. 

 DQK

Top
Mon, 2019-07-22 12:59
#3
Zoltan Palffy
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
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

Top
Sat, 2019-07-20 04:39
#4
Kien Dinh
User offline. Last seen 4 years 31 weeks 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

Top
Fri, 2019-07-19 13:47
#5
Zoltan Palffy
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
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 
Top