3.1.3 Checking the Excel security level

Excel macros are used for JP1/AJS3 - Definition Assistant functions. Check the Excel security level for the version of Excel you are using.

Organization of this subsection

(1) For Excel 2002 or Excel 2003
(2) For Excel 2007
(3) For Excel 2010 or later

(1) For Excel 2002 or Excel 2003

If you are using Excel 2002 (Office XP) or Excel 2003 (Office 2003), and you set the security level for Excel to High, you will not be able to use some of the functions in the definition information management template.

If the security level is set to Medium, a warning dialog box will appear when the definition information management template is opened. In this case, choose Enable macros.

To Page Top

(2) For Excel 2007

If you are using Excel 2007 (Office 2007), use either of the following methods to enable Excel macros.

(a) Setting Excel macros by selecting Trust Center and then Macro Settings

In Excel 2007, Trust Center>Macro Settings>Disable all macros with notification is selected by default. When you open the definition information management template in this state, the message Security Warnings Macros have been disabled. is displayed in the message bar. To proceed, click the Options button to open the Microsoft Office Security Options dialog box and then select Enable this content. If you do not do this, Help protect me from unknown content (recommended) is still set, and you will not be able to use some of the functions in the definition information management template.

Supplementary notes:

If you select Trust Center>Macro Settings>Enable all macros (not recommended; potentially dangerous code can run), you can also use all the functions in the definition information management template. Note, however, that this method enables macros for Excel files other than the definition information management template as well.

In addition, if you select Disable all macros without notification or Disable all macros except digitally signed macros, you will be not be able to use some of the functions in the definition information management template.

(b) Setting Excel macros by selecting Trust Center and then Trusted Locations

Use the following procedure to add the file storage folder for the definition information management template used for import or export to Trust Center>Trusted Locations before starting operation.

Start Excel.
Click the Microsoft Office button at the upper left of the window, and then click the Excel Options button.

The Excel Options dialog box appears.
Select Trust Center in the area on the left, and then click the Trust Center Settings button in the area on the right.

The Trust Center dialog box appears.
Select Trusted Locations in the area on the left, and then click the Add new location button in the area on the right.

The Microsoft Office Trusted Location dialog box appears.
Enter the path to the file storage folder containing the definition information management template for import or export in Path. Alternatively, click the Browse button to specify the file storage folder containing the definition information management template for import or export.
Select Subfolders of this location are also trusted, and then click the OK button.
Make sure that the path to the folder specified in step 5 has been added to Trusted Locations in the area on the right of the Trust Center dialog box.

If there are multiple file storage folders for definition information management templates for import or export, repeat steps 4 to 6 for each folder.

To Page Top

(3) For Excel 2010 or later

When you use the product with Excel 2010 or later (Office 2010 or later), perform either of the following methods to enable Excel macros.

(a) Setting Excel macros by selecting Enable Content

In Excel 2010 or later, Trust Center>Macro Settings>Disable all macros with notification is selected by default. When you open the definition information management template in this state, the message Security Warnings Macros have been disabled. is displayed in the message bar. To proceed, click the Enable Content button.

Supplementary notes:

In addition, if you select Disable all macros without notification or Disable all macros except digitally signed macros, you will not be able to use some of the functions in the definition information management template.

(b) Setting Excel macros by selecting Trust Center and then Trusted Locations

Start Excel.
Select the File tab and then click Options.

The Excel Options dialog box appears.
Select Trust Center in the area on the left, and then click the Trust Center Settings button in the area on the right.

The Trust Center dialog box appears.
Select Trusted Locations in the area on the left, and then click the Add new location button in the area on the right.

The Microsoft Office Trusted Location dialog box appears.
Enter the path to the file storage folder for the definition information management template for import or export in Path. Alternatively, click the Browse button to specify the file storage folder for the definition information management template for import or export.
Select Subfolders of this location are also trusted, and then click the OK button.
Make sure that the path to the folder specified in step 5 has been added to Trusted Locations in the area on the left of the Trust Center dialog box.

If there are multiple file storage folders for definition information management templates for import or export, repeat steps 4 to 6 for each folder.

To Page Top