Smartview Menu Does not Appear in the Excel Menu Bar

Modified 30-JUL-2010

---

Applies to:

Hyperion Financial Management - Version: 9.3.1.0.00 to 11.1.1.0.00 - Release: 9.3 to 11.1
Microsoft Windows (32-bit)

Symptoms

SmartView menu does not appear in the Excel menu bar (Office 2003) or Hyperion tab does not appear in the Ribbon (Office 2007)

Cause

Possible causes:

1. The SmartView DLLs are missing or have not been registered successfully during installation.

2. SmartView Add-in has been disabled by Excel.

Solution

Overview
1. Check that SmartView is enabled
2. Re-install

1. Check that SmartView is enabled
Office 2003:
1.1. Point to Help > About Microsoft Office Excel
1.2. Choose Disabled Items... (button at the bottom)
1.3. If SmartView is listed, select it and choose Enable
1.4. Choose Close
1.5. Close and re-open Excel
Office 2007:
1.1. Choose the Office Button
1.2. Choose Excel Options (at the bottom)
1.3. At the left, select Add-Ins
1.4. Check the top section, 'Active Application Add-ins'. It should list SmartView twice -- see the screenshot. Then scroll to the very bottom and look at the 'Disabled Application Add-ins' section.
1.5. If Smart View for Office shown disabled, select it, change the status to enabled and choose OK.
1.6. Choose Close
1.7. Close and re-open Excel


If this resolves the issue but it keeps recurring, please contact Oracle Support for assistance.


2. Re-install
2.1. Uninstall SmartView and check that all files (especially HsAddin.dll) are not present anywhere on the machine
2.2. Re-install