P6 16.2 - xlsx Import error "The User Preferences used to create this Excel file are not the same as your current preferences"

thake a look at these setting in P6 and the xls file 

DurationQtyType=QT_Day

ShowAsPercentage = 0

SmallScaleQtyType=QT_Hour

DateFormat=dd'-'mmm'-'yy

CurrencyFormat = Dollar 

and see if they match 

Hi M N, Santosh is right. The Excel file not importing is is a bug with P6 Version 16.2. I would know because I moved to 16.2 from 16.1 due to another bug in 16.1 where the pop-up resource assignments window would not be visible on my screen. Only to find out that 16.2 has the Excel file importing bug, which is a deal-breaker for me. Unlike previous older versions, installing the Microsoft Access Database Engine 2010 will not resolve the issue this time. Your options are either to:

1. Apply the patch in which case you must be able to access Oracle Support
2. Or upgrade to a later version (which I did, in P6 V18.8)

There was a previous post about this error here: Excel Import in P6 16.2 error message.... PLZ HELP | dedicated to Project Controls (planningplanet.com)

Where the solution appeared to be to apply a patch, perhaps upgrading to a later version of P6 will resolve?

The item on Oracle's Support site is:

"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)"

Sorry I'm unable to access the above to see what they recommend.