Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Error in P6 R16.2 importing

1 reply [Last post]
O S
User offline. Last seen 6 years 17 weeks ago. Offline
Joined: 30 Jun 2010
Posts: 3
Groups: GPC Qatar

I am curious if anyone is experiencing this issue. I can export a .xlsx from P6 R16.2. I can open the file just fine in Excel . However, if I save it in Excel  without making any changes and try to import it into P6 R16.2, I get this 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?"

 

I've tried everything that I know how to do and searched and searched the Oracle/Primavera Knowledge Base. Apparently there is a setting in Excel 2016 that "corrupts" the data and there is some user preference setting in Excel 2016 that does not align with my user settings in P6 R16.2.

 

Has anyone experienced this issue? Any insight, tips, tricks, would be greatly appreciated

Replies

Zoltan Palffy
User offline. Last seen 23 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

If this recently began to happen I believe that is is an error due to a security patch update from excel. You have 2 options

option #1 roll back the microsoft security path to an earlier verison

option #2 get an updated patch from Oracle