Exporting Problem from Primavera to Excel

K
Kien Dinh 👤 Member for 6 years 10 months

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

K
Kien Dinh 👤 Member for 6 years 10 months

Dear sỉ,

Trying this way has solved the issues. 

 DQK

Z
Zoltan Palffy 👤 Member for 16 years 10 months

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

K
Kien Dinh 👤 Member for 6 years 10 months

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.

[[wysiwyg_imageupload:6885:]]

Z
Zoltan Palffy 👤 Member for 16 years 10 months

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 

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts