Where is the security warning area in Excel?

Symptom When opening an Excel file that contains Liberty Reports or Office Connector queries or functions, a yellow notification bar may appear at the top of the worksheet with a "Security Warning".Background

The security warning is not due to your Liberty Reports or Office Connector software and does not indicate that there is a problem with the file. Microsoft Excel [like other Office applications] includes security features that are designed to help protect your computer from harmful content. As an example, Office documents [Excel, Word, Access, PowerPoint] can contain macros. If you received a file from an untrusted source, it's possible that it could contain macros that would be harmful to your computer or jeopardize your data if those macros were allowed to execute when the document is opened. By default, the security features of Microsoft Office disables untrusted macros and allows you the option to allow them to execute or not. Likewise, Microsoft Office documents can also contain links [i.e., Data Connections] to your company data. A document containing Data Connections received from an untrusted source could also be potentially harmful for similar reasons. If the query of the Data Connection were allowed to execute, damage could be done to information or sensitive information could be exposed. Again, for this reason, Data Connections within a document from an untrusted source are disabled by default and you have the option to enable them.

Solution

In the case of Excel files that contain Liberty Reports or Office Connector functionality, you may wish for the security warning prompt to be automatically disabled [because you trust the content of these files]. You can control this via the the Trust Center Settings in Excel Options. Additionally, a digital signature is a way to identify that a document is from a trusted source. All files provided by Event 1 with your software include Event 1's digital signature.

The following Microsoft article describes the security features and how to control the security prompt:
//support.office.com/en-au/article/Block-or-unblock-external-content-in-Office-documents-10204ae0-0621-411f-b0d6-575b0847a795

Job Management Partner 1 Version 10, Job Management Partner 1/Automatic Job Management System 3 - Definition Assistant Description, Operator's Guide and Reference

3.1.3 Checking the Excel security level

[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.

[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.

1. Start Excel.
2. 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.
   
3. 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.
   
4. 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.
   
5. 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.
6. Select Subfolders of this location are also trusted, and then click the OK button.
7. 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.

[3] For Excel 2010

When you use the product with Excel 2010 [Office 2010], perform either of the following methods to enable Excel macros.

[a] Setting Excel macros by selecting Enable Content

In Excel 2010, 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: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 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.

1. Start Excel.
2. Select the File tab and then click Options.
   The Excel Options dialog box appears.
   
3. 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.
   
4. 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.
   
5. 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.
6. Select Subfolders of this location are also trusted, and then click the OK button.
7. 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.
   

Copyright [C] 2013, Hitachi, Ltd.
Copyright [C] 2013, Hitachi Solutions, Ltd.