Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Excel Import in P6 16.2 error message.... PLZ HELP

In the Open Standard
Tom MorganMember for 9 years 5 months
Created
8
4
0

I am trying to import a line, list IDs and Activity name is all i really need. In 16.2 it is giving me this error message....

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?

Running office 13 same steps i always used in 15.2, 7 and 8

When it finally gets through it only adds 1 activity. Anyone else have this problem and find a solution?

Save Follow Follow forum Report
Reply New topic

8 replies

Oldest first
  1. 0
    Ed Jones ·
    #1

    You did not create the export

    You did not create the export file or the template you used.  Create a similiar tempalte yourself by running an export.  Then copy paste the data from the import you are trying to run to your new file.  Should work with no problem.

    Report
  2. 0
    Ed Jones ·
    #2

    You did not create the export

    You did not create the export file or the template you used.  Create a similiar tempalte yourself by running an export.  Then copy paste the data from the import you are trying to run to your new file.  Should work with no problem.

    Report
  3. 0
    Tom Morgan ·
    #3

    I exported out added my line

    I exported out added my line list and activity numbering then it only adds the 1 activity on the way back in.... its getting frustrating! I tried my import template from 15.2 and it hasnt worked either. 

    Report
  4. 0
    Tom Morgan ·
    #4

    i am getting this errorERROR:

    i am getting this error

    ERROR: Failed to find a matching object for Activity

    ERROR: Failed to find a matching object for Activity
    Report
  5. 0
    Tom Morgan ·
    #5

    For reference if anyone else

    For reference if anyone else has this problem the Patch for 16.2.6 fixed the issue

    Report
  6. 0
    Bryan Fardyanto ·
    #6

    Dear All, please need your

    Dear All, please need your help  with my problem Primavera 16.2, is not working properly  the problem information  :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?

    Report
  7. 0
    Zoltan Palffy ·
    #7

    you usually get this error

    you usually get this error when the format of the excel file being imported is different from the current user prefernce settings and the project settings are different for these fields 

    Duration Type IE. fixed Duration and Units /time 

    Quanity type IE. hours

    Date format IE. dd-mmm-yy

    Currency format IE. Dollars 

    Report
  8. 0
    Bryan Fardyanto ·
    #8

    Dear All , problem for

    Dear All , problem for import  excel file  to primavera 16.2, maybe  anyone  can help solution  information  ,

    Report

Log in or join to reply

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

Log inJoin free

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