My Oracle Support Banner

Error: "The User Preferences Used to Create This Excel File Could Not Be Found..." When Attempting to Import an Excel Spreadsheet Into P6 Professional (Doc ID 899144.1)

Last updated on MARCH 24, 2020

Applies to:

Primavera Contractor - Version 6.1 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.2.4.0 and later
Primavera P6 Standard Project and Portfolio Management Cloud Service - Version 16.2.13.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 6.1 and later
All Platforms

Symptoms

Steps for Cause/Solution 3:

  1. Open sample Project and Export to XLSX.
  2. Open XLSX in Excel and change the Activity Name of a single Activity. Save & Close the file.
  3. Import the updated XLSX.
    1. 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.
    2. After clicking Finish/processing import file: Process did not complete successfully. See log file for details.
    3. In prm_xlsximport.log: ERROR: Failed to find a matching object for Activity [for every Activity that was not modified in the file].
    4. If you only import single row that was modified in the XLSX, import states completed successfully, but no changes were made.

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
 Cause 1:
 Cause 2:
 Cause 3:
Solution
 Fix for Cause 1:
 Fixes for Cause 2:
 Fix for Cause 3:
References

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