NMS Storm Mgmt Template Workbook Does Not Work In Microsoft Excel 2010 or Newer

(Doc ID 2364015.1)

Last updated on FEBRUARY 27, 2018

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.3 to 2.3.0.1.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 1.12.0.3 to 2.3.0.1.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.

Symptoms

The Oracle NMS Storm Mgmt Template r1.8 v2.0 will not work in Excel 2010 or newer.

We have verified that this spreadsheet will work in Excel 2007 but not in newer versions. Is there any way we can have the worksheet updated to work in newer versions of Excel?

ERROR
-----------------------
Microsoft Visual Basic for Applications dialog appears



Compile error:
Can't find project of library



The issue can be reproduced  with the following steps:

  1. Open up the Storm Management Workbook
  2. Select the Tools tab
  3. Enter a Project Name and a valid Output File and path
  4. Select the "Generate Configuration" button



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms