My Oracle Support Banner

Importing an Exported Excel Back to P6 Professional Shows Error, 'The User Preferences used to create this Excel file are not the same as your current preferences.' (Doc ID 2429376.1)

Last updated on JANUARY 01, 2021

Applies to:

Primavera P6 Professional Project Management - Version 17.12.5.0 to 17.12.6.0 [Release 17.12]
Primavera P6 Enterprise Project Portfolio Management - Version 17.12.5.0 to 17.12.6.0 [Release 17.12]
Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 to 16.2.14.0 [Release 16.2]
Primavera P6 Professional Project Management - Version 16.2.0.0 to 16.2.14.0 [Release 16.2]
Information in this document applies to any platform.

Symptoms

When attempting to Import an Exported Excel back to P6 Professional, the following error occurs:

ERROR
-----------------------
"The User Preferences used to create this Excel file are not the same as your current preferences. Importing this file could corrupt your data. Please refer to Help for more information about importing data from Excel. Are you sure that you want to continue?"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log on P6 Professional.
2. Export a Project to Excel.
3. Make nothing or just a few change to this Excel file.
4. Import this Excel back to P6 Professional. See above error/warning.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import an Excel file to P6 Professional.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.