1.7.4 Notes on Excel
-
When the macro security level in Excel is high, some parts of the definition information management template function become unusable. Change the security level so that you can use all parts of the function.
-
Do not enable the Ignore other applications Excel option. JP1/AJS3 - Definition Assistant will not run when this option is enabled.
-
When JP1/AJS3 - Definition Assistant is running on Excel 2002 and a number more than 310 digits is input in a cell, even if the input value is larger than the limit, an error message might not be output. If you have entered a number more than 310 digits in a cell, make sure that you press the Enter key to set the entered value.
-
When you want to use JP1/AJS3 - Definition Assistant, specify the settings so that the Excel macros that JP1/AJS3 - Definition Assistant uses will be enabled. If you do not specify these settings, some JP1/AJS3 - Definition Assistant functions will not be available. For details, see 3.1.3 Checking the Excel security level.
-
When you open a master file or execution results file in Excel 2007 or later, Compatibility mode is displayed in the title bar, indicating that the master file was created in an Excel format belonging to a version earlier than Excel 2007. However, operation is not affected.
Note that if you are using JP1/AJS3 - Definition Assistant in Excel 2007 or later, and you edit and save an execution results file, you need to save the file in xls format, which is an older format. If you use the xlsx format, which is the format of Excel 2007 or later, to save the file, JP1/AJS3 - Definition Assistant functions will not work properly.
-
Before starting JP1/AJS3 - Definition Assistant, close all the other Excel files.