• Linked Applications
    Loading…

Smartview Generates Excel Error

When using SmartView, an Excel add-in for Hyperion Planning, you get an error message that "C:\Hyperions\SmartView\Bin\HsTbar.xla" could not be found.

Smart View Error Message

First, check if you have the latest version of SmartView installed.  This version will have a menu option of "Smart View" in Excel.  The older version of SmartView will have a menu option of "Hyperion" in Excel.

Checking Version of Excel for Smartview

If you have the latest version of SmartView installed, you can use the following instructions to resolve the problem:

  1. Close Excel if it is currently open.
  2. Use Windows Explorer to navigate to this directory:  C:\oracle\SmartView\install
  3. Run the "removeExcelOpenKey.vbs" file
  4. Close the window

If SmartView is an older version or is no longer needed, your technical support person can help remove the reference to Hyperion (SmartView) from Excel using the "removeExcelOpenKey.vbs" script found in the zip file below:

removeExcelOpenKey.zip