When I try and re-import from an exported permissions excel file, projectWise returns me the error message `Unable to import from excel. Make sure Excel 2003 or newer is installed'.

When I try and re-import from an exported permissions excel file, projectWise returns me the error message `Unable to import from excel. Make sure Excel 2003 or newer is installed'. I have installed office 2010 and 2016 and get the same result, I have tried importing the xlsx and the csv and I get the same result. I have attempted to do the import using ProjectWise V8i and ProjectWise CONNECT and I get the same result.

#can successfully export the access control to xlsx
Export-PWAccessControlToExcel -ExportFolder $Path -ExportFileName "H999995_accesscontrol" -InputFolder $ProjectToArchive -AllLevels

#can successfully export the access control to csv
Export-PWAccessControlToExcel -ExportFolder $Path -ExportFileName "H999995_accesscontrol" -InputFolder $ProjectToArchive -ExportFileExtension 'csv' -AllLevels

#unable to import the access control from xlsx
Import-PWAccessControlFromExcel -ImportFileNamePath 'C:\temp\Export\PWArchive\H999995_accesscontrol.xlsx' -InputFolder 'Projects\Hatch Internal\SiteABC\H999995'

#unable to import the access control from csv
Import-PWAccessControlFromExcel -ImportFileNamePath 'C:\temp\Export\PWArchive\H999995_accesscontrol.csv' -InputFolder 'Projects\Hatch Internal\SiteABC\H999995'

Kind regards
Gavin Chapman

gavin.chapman@hatch.com