Skip to content

Exporting Problem from Primavera to Excel

Kien DinhMember for 7 years 3 months
Created
5
1
0

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

5 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    Issue is caused by the

    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 
  2. 0
    Kien Dinh ·

    Dear Zoltan,Thank for the

    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.

  3. 0
    Zoltan Palffy ·

    go to edit users

    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

  4. 0
    Kien Dinh ·

    Dear sỉ,Trying this way has

    Dear sỉ,

    Trying this way has solved the issues. 

     DQK

  5. 0
    Zoltan Palffy ·

    glad that I coud help you

    glad that I coud help you 

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?