Setting the security level for excel 2007 – HP 3PAR System Reporter Software User Manual

Page 56

Advertising
background image

1.

Click Enable Macros to continue launching the Excel client.

If you do not see the Security Warning, try completing

Step 2

through

Step 5

to set the macro

security level for Microsoft Excel 2003, before continuing.

2.

On the Microsoft Excel Tools menu, point to Macro, then Security.

The Security dialog box appears with the Security Level tab enabled (

Figure 17 (page 56)

).

Figure 17 Setting the Security Level

3.

On the Security Level tab, set the security level to Medium or Low (Medium is the default and
suggested setting) and then click OK.

NOTE:

The HP 3PAR System Reporter Excel client will not work if the Microsoft Excel security

level is set to High or Very High.

4.

If you changed the security level setting, close the Excel workbook and then reopen it.

With a security setting of Medium, Excel will prompt you when the workbook is opened to
specify whether or not macros should be enabled.

5.

You need to select Enable Macros for the workbook to function.

NOTE:

Please consult your company’s security policy before changing any security settings.

Setting the Security Level for Excel 2007

In most cases, when accessing the System Reporter client for Excel 2007, a security warning,
indicating that macros have been disabled, is shown in the upper left part of the screen. If you do
not see the Security Warning, try completing

Step 4

through

Step 9

before continuing.

To enable macros for the current session, follow these steps:

56

Getting Started

Advertising