Import using Excel does not work

Owned by Mattias Löfstrand
Last updated: 06 Oct 2016
1 min read

Problem


Import of part assemblies or parts using Microsoft Excel fails with a log message indicating insufficient permissions.

Solution


Excel based import requires macros to be turned off. Due to this, Excel import has a function to create a temporary copy of the Excel file, where macros will be turned off in this temporary file. In some cases user does not have permissions to create this temporary file. The reason is commonly one of these two:

  • Due to corporate policies, applications may not create temporary files.
  • Office older than 2007 is used, which is not supported by Assert.

Ensure to use Office 2007 or later. Manually create a temporary file with no macros and use this file for import. Also turn off the automatic creation of temporary files in import.config.

Turn off temporary files in an import by setting the below

<ExcelPartAssemblyConfig config-name="Sample part assembly import" remove-macros="false">

<ExcelPartConfig config-name="Sample part import" remove-macros="false">